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

115 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
whininesses174618(None) 
shininesses1448291shininesses
brininesses1338982brininesses
phoninesses1636452phoninesses
raininesses11310482raininesses
spininesses1358452spininesses
thingnesses1545192thingnesses
thinnesses1346262thin_nesses
tininesses10311162_tininesses
whininess1535122whinine_s_s
whitenesses1746652whitenesses
wilinesses131911092w_ilinesses
windinesses1557812w_indinesses
wirinesses131811522w_irinesses
airinesses102613613_airinesses
blindnesses1446183blindnesses
boninesses121111453_boninesses
bonninesses1337353bonninesses
braininesses1446553braininesses
canninesses1368853canninesses
chancinesses1945033chancinesses
charinesses1639563charinesses
chewinesses1945143chewinesses
chicnesses1745213chi_cnesses
chillinesses1744983chillinesses
chillnesses1644723chillnesses
corninesses13410593corninesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
dinginesses1337473_dinginesses
downinesses1536143downinesses
faintnesses1447143faintnesses
finenesses13310713_finenesses
flintinesses1546323flintinesses
funninesses14106873funninesses
graininesses1346593graininesses
griminesses14167553griminesses
hairinesses14198943hairinesses
handinesses151410273_handinesses
hazinesses2239223_hazinesses
highnesses1746083_highnesses
hillinesses1458503_hillinesses
hipnesses1436753_hi_pnesses
hippinesses1845493_hippinesses
hokinesses1758943_hokinesses
holinesses13511493_holinesses
hominesses15510863_hominesses
horninesses1459003horninesses
icinesses11310073__icinesses
inkinesses1439423__inkinesses
juicinesses2035893juicinesses
kindnesses1537213_kindnesses
kinkinesses1435873_kinkinesses
liminesses121310853_liminesses
looninesses1197993looninesses
mirinesses121512313_mirinesses
mooninesses13127943mooninesses
noisinesses1139483noisinesses
oilinesses101512443_oilinesses
pinknesses1636583_pinknesses
pipinesses1448603_pipinesses
pixinesses1937373_pixinesses
puninesses121110753_puninesses
riminesses121211413_riminesses
runninesses11137693runninesses
shadinesses1538643shadinesses
shakinesses1837613shakinesses
shiftinesses18105243shiftinesses
shininess1237333shinine_s_s
showinesses1735993showinesses
sizinesses1938653_sizinesses
skinninesses1643473skinninesses
sliminesses1338093sliminesses
slinkinesses1645813slinkinesses
spicinesses1547103spicinesses
spikinesses1746523spikinesses
stinginesses1375963stinginesses
stoninesses1138253stoninesses
sunninesses11148383sunninesses
tawninesses1436153tawninesses
thicknesses2043913thicknesses
thorninesses1544393thorninesses
tidinesses1139223_tidinesses
tinninesses1136863tinninesses
vainnesses1337343vain_nesses
wackinesses2036653wackinesses
wannesses1239233w_an_nesses
warinesses131514523w_arinesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wavinesses16199283w_avinesses
waxinesses20138763w_axinesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
weirdnesses1545213weirdnesses
whatnesses1635733wh_atnesses
wheezinesses2742863wheezinesses
wholenesses1745803wholenesses
widenesses1438773w_idenesses
wildnesses14157363w_ildnesses
wimpinesses1835633wimpinesses
wintrinesses1555773w_intrinesses
wisenesses13310823w_isenesses
wispinesses1636273wispinesses
witnesses12219923w_i_tnesses
wittinesses14127483wittinesses
woodinesses15127463woodinesses
woolinesses14157503woolinesses
woozinesses23175633woozinesses
wordinesses15138883wordinesses
worminesses16127993worminesses
wornnesses1337133worn_nesses
wrongnesses1544923wrongnesses
zaninesses19310383_zaninesses

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.390458182.1
2DLD Change Limit1216331154.78025446.2
3Display Results1151150.0631825.4
 (SQL Overall)1786911155.23334147.0
 
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.