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

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

60 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
loathnesses144586(None) 
latenesses10413362l_atenesses
loaminesses1358452loaminesses
loathness1244702loathne_s_s
loftinesses1437922loftinesses
lostnesses1049302lost_nesses
brashnesses1646553brashnesses
coatdresses1443943coatdresses
dottinesses1238133dottinesses
fatnesses121710463_fat_nesses
flatnesses1337763flat_nesses
foaminesses1658073foaminesses
goutinesses1239983goutinesses
hoarinesses14310223hoarinesses
hotnesses1238903ho_t_nesses
iratenesses11411443iratenesses
lacinesses12312123l_acinesses
lamenesses12610563l_amenesses
lanknesses1437503l_anknesses
laxnesses1646633l_a_xnesses
lazinesses19310153l_azinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leannesses10108343lea_nnesses
lightnesses1546143lightnesses
litenesses10513023l_itenesses
lithenesses1447313l_ithenesses
localnesses1345853localnesses
loginesses11410323lo_ginesses
lonenesses10311343lo_nenesses
longnesses1138503lo_ngnesses
looninesses1197993looninesses
loopinesses13116733loopinesses
loosenesses1147243loosenesses
lornnesses1037823lo_rnnesses
loudnesses1138433lo_udnesses
lousinesses111210333lousinesses
loutishnesses1644993loutishnesses
lowlinesses1436683lowlinesses
lownesses1236983lo__wnesses
lushnesses1337343l_ushnesses
lustinesses11910423lustinesses
matinesses12314543_matinesses
meatinesses13311983meatinesses
mootnesses1237153moot_nesses
neatnesses10310013neat_nesses
patnesses111611793_pat_nesses
poshnesses1537463po_shnesses
pottinesses1339103pottinesses
rashnesses1338723_rashnesses
rootinesses1139523rootinesses
roughnesses15105133roughnesses
slatinesses11311633slatinesses
smoothnesses1762653smoothnesses
soapinesses1339713soapinesses
softnesses1337603soft_nesses
sootinesses11410053sootinesses
toughnesses15104483toughnesses
whatnesses1635733what_nesses
worthinesses1845763worthinesses

Search took 6 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 Filter1786911216330.436409841.7
2DLD Change Limit121633604.78325430.3
3Display Results60600.0302000.0
 (SQL Overall)178691605.24934042.9
 
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.