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

191 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
beadinesses144955(None) 
headinesses1539841headinesses
readinesses12611261readinesses
badnesses1239242b_ad_nesses
bandinesses14109722bandinesses
bawdinesses17126312bawdinesses
beadiness12249232beadine_s_s
beefinesses1675942beefinesses
beerinesses1398902beerinesses
blearinesses1446542blearinesses
deadlinesses1446222deadlinesses
deadnesses1238942dead_nesses
easinesses10314412_easinesses
heavinesses1747452heavinesses
leafinesses1437872leafinesses
leakinesses1538472leakinesses
mealinesses13310972mealinesses
meatinesses13311972meatinesses
needinesses1258102needinesses
nerdinesses1249042nerdinesses
reedinesses1259552reedinesses
seaminesses13310752seaminesses
seedinesses1259202seedinesses
shadinesses1538642shadinesses
steadinesses1346902steadinesses
tearinesses11311692tearinesses
wearinesses14310212wearinesses
weedinesses1557072weedinesses
bagginesses1545943bagginesses
baldnesses1337643b_aldnesses
balkinesses1767493balkinesses
balminesses1537243balminesses
barenesses12311693b_arenesses
baronesses1238903b_aronesses
basenesses12310553b_asenesses
bassnesses1136833b_assnesses
battinesses13169443battinesses
beardednesses1744123beardednesses
bearishnesses1844843bearishnesses
beastlinesses1563423beastlinesses
biasnesses1236943bia_snesses
bittinesses13148253bittinesses
blacknesses1944993blacknesses
blandnesses1446623blandnesses
blanknesses1744933blanknesses
bleaknesses1744033blea_knesses
bloodinesses1544263bloodinesses
blowinesses1635973blowinesses
bogginesses1555663bogginesses
boldnesses1337223bold_nesses
boninesses121111443b_oninesses
bonninesses1337343bonninesses
boozinesses22175793boozinesses
boskinesses17136803boskinesses
bossinesses12117343bossinesses
boxinesses19127893b_oxinesses
braininesses1446543braininesses
brashnesses1646543brashnesses
brassinesses1346053brassinesses
brattinesses1466253brattinesses
bravenesses1647943bravenesses
brawninesses1744703brawninesses
breathinesses1853653breathinesses
breezinesses2343943breezinesses
brininesses1338973brininesses
broadnesses1446183broad_nesses
broodinesses1544733broodinesses
bugginesses1545363bugginesses
bulginesses1466123bulginesses
bulkinesses1786473bulkinesses
bumpinesses17126363bumpinesses
burlinesses1338393burlinesses
bushinesses16107453bushinesses
businesses121411353b_usinesses
bustinesses131310073bustinesses
caginesses13310933_caginesses
cakinesses16310603_cakinesses
charinesses1639563charinesses
crazinesses2237923crazinesses
creakinesses1845983creakinesses
creaminesses1646123creaminesses
deaconesses1445653deaconesses
deafnesses1436223dea_fnesses
dearnesses1139573dea_rnesses
dewinesses1438343de_winesses
dowdinesses1635723dowdinesses
dreaminesses1545703dreaminesses
drearinesses1347433drearinesses
earlinesses11311033_earlinesses
edginesses1236683_edginesses
eerinesses10612573_eerinesses
fetidnesses1546643fetidnesses
flakinesses1837073flakinesses
foaminesses1658063foaminesses
freakinesses1945583freakinesses
gaminesses13410453_gaminesses
gaudinesses1337843gaudinesses
geekinesses1635813geekinesses
gelidnesses1355983gelidnesses
gemminesses1634973gemminesses
germinesses1437873germinesses
giddinesses1435303giddinesses
gladnesses1236683glad_nesses
glarinesses1239513glarinesses
glazinesses2136403glazinesses
grapinesses1438563grapinesses
greasinesses1347033greasinesses
greedinesses1446453greedinesses
handinesses151410273handinesses
hardinesses151110213hardinesses
hazinesses2239213_hazinesses
headdresses1683693headdresses
headiness132510363headine_s_s
heartinesses1547993heartinesses
heftinesses1737133heftinesses
hoarinesses14310213hoarinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
lacinesses12312103_lacinesses
lazinesses19310143_lazinesses
leadennesses1354573leadennesses
leannesses10108343lea_nnesses
leerinesses11119473leerinesses
legginesses1345293legginesses
lewdnesses1435393lewd_nesses
loaminesses1358443loaminesses
madnesses1239833_mad_nesses
matinesses12314523_matinesses
mazinesses2139903_mazinesses
meannesses12128163mea_nnesses
merrinesses1358253merrinesses
messinesses1297503messinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
muddinesses1535263muddinesses
nearnesses1039093nea_rnesses
neatnesses10310003nea_tnesses
nervinesses1437303nervinesses
newsinesses1436313newsinesses
peartnesses1338713peartnesses
peppinesses1435313peppinesses
perkinesses1748913perkinesses
peskinesses1746563peskinesses
pettinesses1338623pettinesses
quakinesses2436283quakinesses
queasinesses2144133queasinesses
racinesses12313493_racinesses
randinesses121311203randinesses
readdresses1394513readdresses
readiness102611853readine_s_s
realnesses10310843rea_lnesses
rednesses10312303re_d_nesses
rowdinesses1536963rowdinesses
ruddinesses1336023ruddinesses
sadnesses10310303_sad_nesses
sandinesses12911393sandinesses
scalinesses1339313scalinesses
scarinesses1339903scarinesses
sexinesses1739203se_xinesses
shakinesses1837613shakinesses
slatinesses11311613slatinesses
sleazinesses2145373sleazinesses
snakinesses1538553snakinesses
sneakinesses1645903sneakinesses
soapinesses1339703soapinesses
spacinesses1538093spacinesses
speedinesses1545593speedinesses
staginesses1238463staginesses
staidnesses1237193staidnesses
steaminesses1446223steaminesses
sweatinesses1546903sweatinesses
tardinesses121110243tardinesses
tepidnesses1445383tepidnesses
testinesses111210313testinesses
threadinesses1753333threadinesses
tidinesses1139213_tidinesses
trendinesses1346323trendinesses
tweedinesses1643613tweedinesses
uneasinesses1246623uneasinesses
unreadinesses1484573unreadinesses
warinesses131514513_warinesses
wavinesses16199273_wavinesses
waxinesses20138753_waxinesses
weaklinesses1944483weaklinesses
weaknesses1735463wea_knesses
weepinesses1646133weepinesses
windinesses1557813windinesses
woodinesses15127463woodinesses
wordinesses15138873wordinesses
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.283631417.0
2DLD Change Limit1216331917.20316886.4
3Display Results1911910.1231552.8
 (SQL Overall)1786911917.60923484.2
 
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.