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 “descanting” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
descanting144692(None) 
decanting132510631de_canting
discanting1449451discanting
desalting1138842des_alting
desanding12207652des_anding
descending1546112descending
recanting122414822re_canting
scanting113914762__scanting
canting104725903___canting
deaconing1337193deacon_ing
deaning94020473de__an_ing
debating123213733de_ba_ting
decamping1734943de_camping
decaying15239453de_ca_ying
decentring1446753de_centring
decocting1538123de_cocting
dedicating1539143dedica_ting
defanging1535333de_fanging
defatting1436103de_fatting
defeating142311973defea_ting
defecating17237783defeca_ting
deflating142610713defla_ting
delating103119603de_la_ting
demanding14237923de_manding
demasting1338453de_masting
demeaning1337243demean_ing
dementing13311043de_menting
demounting1444963demounting
denting94422183de___nting
depainting14156153depainting
departing1349513de_parting
deplaning1338053deplan_ing
deranging1238063de_ranging
derating103222283de_ra_ting
deratting1139513de_ratting
descant104315593descant___
descanted1336673descant_ed
descanter1246443descant_er
descanters1345013descanters
descants112910143descant__s
describing1645073describing
descrying1635103desc_rying
desecrating1548093desecrating
deserting11713143des_erting
desiccating1744703desiccating
designating1446073designating
designing1236623design_ing
desisting112810383des_isting
desolating1239463desolating
despairing1445063despairing
despiting13179323des_piting
desponding1555663desponding
destaining1267943destaining
destining11311433destin_ing
detonating1248823detonating
detracting1438713detracting
deviating14311083devia_ting
disbanding1545583disbanding
discarding1547343discarding
discasing1339433disca_sing
discepting1658473discepting
discounting1547443discounting
dismantling1543393dismantling
dismasting1446383dismasting
disparting1438933disparting
displanting1546043displanting
disrating11714553disra_ting
dissenting121310293dissenting
distancing1447083distancing
distasting1248023distasting
educating1337933educa_ting
enchanting1645943_enchanting
escalating1347093_escalating
escaping1347063_esca_ping
escarping1435203_escarping
escorting1237713_escorting
escoting1158713_esc_oting
estating92614993_esta_ting
gestating11229983gesta_ting
incanting1289903_incanting
levanting1345523le_vanting
merchanting1944313merchanting
miscasting1557073miscasting
recaning111416693re_can_ing
recasting122414233re_casting
regranting1238323regranting
replanting1338523replanting
rescaling122212013resca_ling
rescinding1436723rescinding
reseating102421533resea_ting
resenting102619293res_enting
resinating11313733resinating
reslating102516993resla_ting
resonating11311263resonating
restarting11310663restarting
restating102319413resta_ting
scanning113310773__scanning
scantling12107233__scantling
scarting113415263__scarting
scatting113311813__scatting
scenting113212813__scenting
slanting94115093__slanting
tenanting1036213te_nanting
vesicating1646903vesica_ting
webcasting1842483webcasting

Search took 8 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 Filter1786911406030.423422437.4
2DLD Change Limit1406031056.90320368.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.37224239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.