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

319 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
rootless8391044(None) 
bootless103410981bootless
footless113710801footless
roofless11316731roofless
rootles73215631rootle_s
rootlets8308651rootlets
blotless10347142blotless
boltless10338282boltless
boonless10328352boonless
bootlegs11325872bootlegs
broodless1235032broodless
coatless1039692coatless
cookless14258632cookless
costless10310002costless
doorless936712doorless
foodless12338382foodless
footlers113910792footlers
footles103715712footle_s
frontless1235402frontless
frostless1235742frostless
hoodless12289732hoodless
hoofless14258012hoofless
hookless151238362hookless
hoopless13279252hoopless
knotless1264562knotless
loftless1135902loftless
moonless10278042moonless
mootness1036752mootness
plotless10256792plotless
poetless1038722poetless
portless10310642portless
restless82713162restless
riftless1136942riftless
roadless937702roadless
rockless14297292rockless
rodless8310072r_odless
rooters74522932root_ers
rootiest83115592rootiest
rootiness979062rootiness
rootle63214452rootle__
rootled83410532rootle_d
rootlet73015732rootle_t
rustless83510242rustless
spotless1037042spotless
toolless836342toolless
toothless1244682toothless
tootlers8289502tootlers
tootles72915602tootle_s
woodless12278452woodless
armorless1143483armorless
arrowless1242803arrowless
artless73712513_artless
beatless103311593beatless
beltless10297713beltless
bloodless1234513bloodless
bloomless1342963bloomless
bodiless1135913bodiless
bondless1148813bondless
boneless10310213boneless
boodlers113710743boodlers
boodles103416043boodle_s
booklets14247123booklets
boomlets12246673boomlets
bootees94114473boot_ees
booties94124613bootie_s
bootleg10276633bootle_g
bootlessly1553423bootlessly
bottlers103810013bottlers
bottles94216273bottle_s
bowless123310313_bowless
bractless1335543bractless
brooklets1543683brooklets
browless1346653browless
coalless1038193coalless
codeless112010113codeless
colorless1145683colorless
coolers93522493coo_lers
coolest9318643coo_lest
coolness1037743coolness
cooters94525723coot_ers
cooties93725733cootie_s
cordless11299963cordless
coreless103013833coreless
countless1146373countless
coxless1637743_coxless
crestless1146783crestless
cropless1237793cropless
crownless1443423crownless
crustless1155403crustless
debtless1135653debtless
doodlers10338843doodlers
doodles93614163doodle_s
doolees83711613doo_lees
dottles83912283dottle_s
doubtless1243313doubtless
downless1236363downless
ductless11196313ductless
dustless9328353dustless
egoless836983ego_less
errorless942813errorless
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
floorless1243793floorless
foamless13195843foamless
fogless1138193_fogless
footers104618333foot_ers
footies103721543footie_s
footiest113514913footiest
footle93914383footle__
footled113610763footle_d
footler104011873footle_r
footlessly1663313footlessly
footrest11308853footrest
footrests12244503footrests
foozlers20346073foozlers
foozles19329543foozle_s
fordless12289003fordless
forkless15267433forkless
formless13248083formless
fortress1136753fortress
fretless1138063fretless
frockless1843453frockless
frontlets1244233frontlets
fruitless1244163fruitless
giftless1245173giftless
goalless935723goalless
godless938403_godless
goodness1036253goodness
gormless11235443gormless
groveless13235363groveless
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hiltless11297123hiltless
hitless103211193_hitless
holeless1189363holeless
homeless131110133homeless
hooklets15217203hooklets
hooters104520463hoot_ers
hootiest113115643hootiest
hopeless13118303hopeless
hornless1137363hornless
hostess103210243host_ess
hostlers113310483hostlers
hotness1038613_hotness
hurtless11307783hurtless
jobless16237563_jobless
jointless1634323jointless
jostlers15357683jostlers
jostles143411143jostle_s
joyless17226513_joyless
lintless82710013lintless
listless8269263listless
loamless10235213loamless
looters74419163loot_ers
lordless9277483lordless
lossless835473lossless
lostness837683lostness
loveless1168573loveless
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
mooleys1236863moo_leys
moonlets10247473moonlets
mooters93818623moot_ers
motleys1235683_motleys
motorless1145723motorless
mottlers10388183mottlers
mottles93415803mottle_s
mouthless1444713mouthless
moveless1367753moveless
netless739863_netless
noodles83513193noodle_s
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
odorless934173odorless
oodles73517183_oodle_s
oratress834553oratress
orbless937493_orbless
ostlers72911203_ostlers
outbless1037963_outbless
outlets73616363_outlets
pastless102411203pastless
peltless10267373peltless
pilotless1143993pilotless
poetess938933poet_ess
pointless1135703pointless
poleless1089873poleless
poodles103013513poodle_s
poolers94217423poo_lers
poorness1036363poorness
popeless1288473popeless
portress1038323portress
pottles93816983pottle_s
printless1137513printless
profitless1542763profitless
rainless8129703rainless
rankless12268233rankless
raptness1046733raptness
rattlers83510293rattlers
rattles73217303rattle_s
rayless10239003r_ayless
reckless14257973reckless
reinless8139433reinless
restress82511773restress
ribless93410343r_ibless
rimless9369363r_imless
rindless92510193rindless
rioters73615513riot_ers
riskless1235763riskless
robles85321693r_oble_s
roles56747983r_o_le_s
rollers73117473r_ollers
rontgens944683rontgens
roofers105013903roo_fers
roofies103014413roofie_s
rooftrees1242403rooftrees
rookies113917103rookie_s
rookiest122912173rookiest
roomers95416413roo_mers
roomies93017243roomie_s
roomiest102611993roomiest
roominess1157293roominess
roosers74217873roo_sers
rooses65526233roo_se_s
roosters83514663roosters
rootages939103rootages
rootcaps1243863rootcaps
rooted75424003root_e_d
rootedness1144903rootedness
rooter64926033root_e_r
rootier74915393rootie_r
rootlike1236613rootlike
rootling9269953rootling
roots55933673root___s
ropiness102311073ropiness
rosiness82613173rosiness
rosters73727543rost_ers
rotes56143903r_ot_e_s
rotls55620163r_otl__s
rotters74421393r_otters
rottes64524833r_otte_s
roubles93413513rouble_s
routers74822873rout_ers
routes66129313rout_e_s
ruleless836633ruleless
rumpless12256543rumpless
rungless956733rungless
runless72810423r_unless
rustlers8339853rustlers
rustles73416413rustle_s
ruthless1135413ruthless
saltless8259343saltless
seatless83213003seatless
shitless11249243shitless
shoeless1137803shoeless
slitless8268143slitless
smogless1134053smogless
snowless1145623snowless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
softness1136433softness
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613_sonless
soothers113913433soothers
soothes103917103soothe_s
soothest113312243soothest
sootiest84016753sootiest
sootiness999833sootiness
soulless8218763soulless
soupless10268463soupless
spoutless1134243spoutless
tactless10288463tactless
tentless8229843tentless
textless15245793textless
thowless1434613thowless
tintless8239863tintless
toadless936313toadless
toeless72612393_toeless
tombless1236773tombless
toneless8610393toneless
toolers74416503too_lers
tooters73818773toot_ers
tootle62613813tootle__
tootled83511043tootle_d
tootler73511123tootle_r
tootses72910773tootse_s
topless92511123_topless
townless1135653townless
toyless10268713_toyless
trustless955953trustless
ventless11249053ventless
vestless11258843vestless
voteless1137493voteless
votress1035483_votress
vowless13246603_vowless
wartless11279923wartless
wattless11268723wattless
witless103310983_witless
woolens10398843woo_lens
woolers104214023woo_lers
woollens1144093woollens
wordless12258843wordless
workless15276803workless
worthless1544923worthless
yokeless1535303yokeless
zestless17247433zestless
zoneless1737823zoneless
zoogleas1843373zoogleas
zootiest173311213zootiest

Search took 9 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 Filter1786911461620.1731032896.0
2DLD Change Limit1461623198.11018022.4
3Display Results3193190.1402278.6
 (SQL Overall)1786913198.42321214.7
 
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.