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

242 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
loftless113590(None) 
blotless10347152blo_tless
boltless10338282boltless
bootless103410982bootless
coatless1039692coatless
costless10310002costless
footless113710802footless
giftless1245172giftless
lifeless11228142lifeless
lintless82710012lintless
listless8269262listless
loamless10235212loamless
lofters103912902loft_ers
loftiest1139082loftiest
loftiness1236572loftiness
lordless9277482lordless
lossless835472lossless
lostness837682lostness
loveless1168572loveless
plotless10256792plo_tless
poetless1038722poetless
portless10310642portless
riftless1136942riftless
rootless83910442rootless
softness1136432softness
artless73712513_artless
beatless103311593beatless
beltless10297713beltless
bloodless1234513bloodless
bloomless1342963bloomless
bodiless1135913bodiless
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootlegs11325873bootlegs
bottlers103810013bottlers
bottles94216273bottle_s
bowless123310313bo_wless
cloudless1243153cloudless
coalless1038193coalless
codeless112010113codeless
coffles152610003coffle_s
cookless14258633cookless
cordless11299963cordless
coreless103013833coreless
countless1146373countless
coxless1637743co_xless
cuffless1634293cuffless
daftness1235533daftness
debtless1135653debtless
deftness1236303deftness
doorless936713doorless
dottles83912283dottle_s
doubtless1243313doubtless
downless1236363downless
ductless11196313ductless
dustless9328353dustless
exitless1534883exitless
fatless103212203_fatless
feetless1137383feetless
flockless1843163flockless
floorless1243793floorless
flourless1243533flourless
foamless13195843foamless
fogless1138193fo_gless
foodless12338383foodless
footlers113910793footlers
footles103715713footle_s
fordless12289003fordless
forkless15267433forkless
formless13248083formless
fortress1136753fortress
fretless1138063fretless
frontless1235403frontless
frostless1235743frostless
goalless935723goalless
godless938403go_dless
gormless11235443gormless
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hiltless11297123hiltless
hitless103211193_hitless
holeless1189363holeless
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hornless1137363hornless
hostess103210243host_ess
hostlers113310483hostlers
hotness1038613ho_tness
hurtless11307783hurtless
jobless16237563jo_bless
jointless1634323jointless
jostlers15357683jostlers
jostles143411143jostle_s
joyless17226513jo_yless
knotless1264573knotless
laceless10239853laceless
landless94011173landless
lawless1037033l_awless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
leftest10269463left_est
lefties10312073leftie_s
legless838013l_egless
lensless835583lensless
lidless8309273l_idless
lifters104313783lift_ers
lightless1386073lightless
limbless12246313limbless
limeless10249663limeless
limitless1142943limitless
lineless82711943lineless
lipless9259553l_ipless
littles73212783little_s
littlest8309243littlest
loathers113310443loathers
loathes103513243loathe_s
loathness1244703loathness
lobules92510813lobule_s
locales93715093locale_s
localness1145233localness
locules92812603locule_s
loess55714703lo___ess
lofted103811893loft_e_d
lofter94614723loft_e_r
loftier1037763loftie_r
loftlike1534393loftlike
lofts85518363loft___s
logicless1242523logicless
loginess9310163loginess
loiters74116613loit_ers
lollers72713793lo_llers
loneness8512093loneness
longness938553longness
looters74419163loot_ers
lornness836493lornness
lotoses73713653lo_toses
lotters73921063lo_tters
lottes65322753lo_tte_s
lotuses74011253lo_tuses
loudness937013loudness
lowness1037813lo_wness
loyalest11146723loyalest
luckless14265893luckless
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
moonless10278043moonless
mootness1036753mootness
motleys1235683mo_tleys
mottlers10388183mottlers
mottles93415803mottle_s
mouthless1444713mouthless
moveless1367753moveless
netless739863_netless
normless10235923normless
noseless839513noseless
noteless839403noteless
nounless837253nounless
oarless73913373_oarless
oftest91212003_oft_est
orbless937493_orbless
ostlers72911203_ostlers
outbless1037963_outbless
outlets73616363_outlets
pastless102411203pastless
peltless10267373peltless
pilotless1143993pilo_tless
pleatless1134613pleatless
poetess938933poet_ess
pointless1135703pointless
poleless1089873poleless
popeless1288473popeless
portress1038323portress
pottles93816983pottle_s
profitless1542763profitless
restless82713163restless
roadless937703roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootles73215633rootle_s
rootlets8308653rootlets
rustless83510243rustless
saltless8259343saltless
seatless83213003seatless
shiftless15265303shiftless
shitless11249243shitless
slitless8268143slitless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
softens10347623soft_ens
softest10310603soft_est
softies103414613softie_s
soilless8279033soilless
soleless8910033soleless
songless9218823songless
sonless72612613so_nless
soulless8218763soulless
soupless10268463soupless
spotless1037043spotless
spoutless1134243spoutless
tactless10288463tactless
tentless8229843tentless
textless15245793textless
tintless8239863tintless
toadless936313toadless
toeless72612393to_eless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
toothless1244683toothless
tootlers8289503tootlers
tootles72915603tootle_s
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
ventless11249053ventless
vestless11258843vestless
voteless1137493voteless
votress1035483vo_tress
vowless13246603vo_wless
wartless11279923wartless
wattless11268723wattless
wifeless14277483wifeless
witless103310983_witless
woodless12278453woodless
wordless12258843wordless
workless15276803workless
worthless1544923worthless
yokeless1535303yokeless
zestless17247433zestless
zoneless1737823zoneless

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622426.62322068.9
3Display Results2422420.0932602.2
 (SQL Overall)1786912427.13925030.3
 
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.