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 “leafinesses” 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.

147 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
leafinesses143787(None) 
leakinesses1538471leakinesses
beadinesses1449552beadinesses
beefinesses1675942beefinesses
blearinesses1446542blearinesses
deafnesses1436222deaf_nesses
easinesses10314412_easinesses
headinesses1539842headinesses
heavinesses1747452heavinesses
lacinesses12312102l_acinesses
lazinesses19310142l_azinesses
leafiness1236482leafine_s_s
leannesses10108342lea_nnesses
leerinesses11119472leerinesses
legginesses1345292legginesses
loaminesses1358442loaminesses
mealinesses13310972mealinesses
meatinesses13311972meatinesses
readinesses12611262readinesses
seaminesses13310752seaminesses
sleazinesses2145372sleazinesses
tearinesses11311692tearinesses
wearinesses14310212wearinesses
beerinesses1398903beerinesses
bleaknesses1744033blea_knesses
caginesses13310933_caginesses
cakinesses16310603_cakinesses
charinesses1639563charinesses
cleanlinesses1553883cleanlinesses
cleannesses13135823clea_nnesses
clearnesses13106153clea_rnesses
comfinesses1846903comfinesses
craftinesses1746373craftinesses
crazinesses2237923crazinesses
creakinesses1845983creakinesses
creaminesses1646123creaminesses
daffinesses1834843daffinesses
daftnesses1436383_daftnesses
deaconesses1445653deaconesses
deadlinesses1446223deadlinesses
deadnesses1238943dea_dnesses
dearnesses1139573dea_rnesses
deftnesses1436813de_ftnesses
dewinesses1438343de_winesses
draftinesses1645743draftinesses
dreaminesses1545703dreaminesses
drearinesses1347433drearinesses
earlinesses11311033_earlinesses
edginesses1236683_edginesses
eerinesses10612573_eerinesses
finesses111912333___finesses
flakinesses1837073flakinesses
fleshinesses18114363fleshinesses
fluffinesses1742663fluffinesses
foaminesses1658063foaminesses
freakinesses1945583freakinesses
gaminesses13410453_gaminesses
geekinesses1635813geekinesses
gemminesses1634973gemminesses
germinesses1437873germinesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
goofinesses1535963goofinesses
grapinesses1438563grapinesses
greasinesses1347033greasinesses
hazinesses2239213_hazinesses
heartinesses1547993heartinesses
heftinesses1737133heftinesses
hoarinesses14310213hoarinesses
huffinesses2034113huffinesses
iffinesses1635573_iffinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
lamenesses12610563l_amenesses
lankinesses1539013lankinesses
lanknesses1437503l_anknesses
larkinesses1538993larkinesses
latenesses10413353l_atenesses
laxnesses1646633l_a_xnesses
leadennesses1354573leadennesses
leakiness1337503leakine_s_s
levelnesses1445533levelnesses
lewdnesses1435393le_wdnesses
liminesses121310843l_iminesses
lippinesses1535513lippinesses
loathnesses1445853loathnesses
loftinesses1437913loftinesses
loginesses11410313l_oginesses
looninesses1197993looninesses
loopinesses13116733loopinesses
lousinesses111210303lousinesses
lowlinesses1436683lowlinesses
luckinesses1746633luckinesses
lumpinesses15107103lumpinesses
lustinesses11910403lustinesses
matinesses12314523_matinesses
mazinesses2139903_mazinesses
meannesses12128163mea_nnesses
merrinesses1358253merrinesses
messinesses1297503messinesses
miffinesses1944363miffinesses
nearnesses1039093nea_rnesses
neatnesses10310003nea_tnesses
needinesses1258103needinesses
nerdinesses1249043nerdinesses
nervinesses1437303nervinesses
newsinesses1436313newsinesses
peartnesses1338713peartnesses
peppinesses1435313peppinesses
perkinesses1748913perkinesses
peskinesses1746563peskinesses
pettinesses1338623pettinesses
puffinesses1934503puffinesses
quakinesses2436283quakinesses
queasinesses2144133queasinesses
racinesses12313493_racinesses
realnesses10310843rea_lnesses
reedinesses1259553reedinesses
safenesses1349373_safenesses
scalinesses1339313scalinesses
scarinesses1339903scarinesses
seedinesses1259203seedinesses
selfnesses1335893self_nesses
sexinesses1739203se_xinesses
shadinesses1538643shadinesses
shakinesses1837613shakinesses
slatinesses11311613slatinesses
sleepinesses1445673sleepinesses
snakinesses1538553snakinesses
sneakinesses1645903sneakinesses
soapinesses1339703soapinesses
spacinesses1538093spacinesses
staginesses1238463staginesses
steadinesses1346903steadinesses
steaminesses1446223steaminesses
sweatinesses1546903sweatinesses
testinesses111210313testinesses
uneasinesses1246623uneasinesses
warinesses131514513_warinesses
wavinesses16199273_wavinesses
waxinesses20138753_waxinesses
weaklinesses1944483weaklinesses
weaknesses1735463wea_knesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
yeastinesses1545563yeastinesses
zaninesses19310373_zaninesses

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 Filter1786911216330.1561145455.1
2DLD Change Limit1216331477.15616997.3
3Display Results1471470.0801837.5
 (SQL Overall)1786911477.39224173.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.