Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “dimensional” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

54 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
dimensional145305(None) 
dimension1244742dimension__
dimensionally1962352dimensionally
dimensioned1552462dimensioned
dimensions1344612dimension_s
ascensional1362773ascensional
declensional1551913declensional
diffusional1852243diffusional
digressional1453183digressional
dimensionality2071533dimensionality
dimensioning1652413dimensioning
directional1445443directional
divisional1453953di_visional
extensional1854183extensional
intensional11146583intensional
nondimensional1771493nondimensional
tensional946213__tensional
tridimensional177843tridimensional
unidimensional1771303unidimensional
accessional15103614accessional
adhesional1472644adhe_sional
attentional1154204attentional
bimensal1244114bimens___al
bisectional1554644bisectional
deceptional1654774deceptional
decisional1344834d_ecisional
delusional1153304d_elusional
demential1248694dementi__al
dentinal939504d__enti_nal
dictional1268614di__ctional
difunctional18123374difunctional
dimensionless1661554dimensionless
dispensational1762504dispensational
dissension11135724dissension__
dissensions12175574dissension_s
distension11156274distension__
distensions12146284distension_s
diversion1346454diversion__
diversionary1962034diversionary
diversions1446534diversion_s
expansional2052804expansional
fissional1245134fi__ssional
ideational1146504_ideational
illusional1053404_illusional
impersonal1454744_impers_onal
intentional11128854intentional
missional1146064__missional
monsoonal1144054__monsoonal
obsessional1353354obsessional
recessional1354994recessional
reversional1454034reversional
sessional946124__sessional
versional1245864__versional
visional1146664vi___sional

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.453394461.4
2DLD Change Limit148819548.98616561.2
3Display Results54540.0301800.0
 (SQL Overall)178691549.46918871.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.