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

274 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
noteless83940(None) 
noseless839511noseless
voteless1137491voteless
boneless10310212boneless
codeless112010112codeless
coreless103013832coreless
dateless9259962dateless
gateless9279952gateless
holeless1189362holeless
homeless131110142homeless
hopeless13118302hopeless
knotless1264572knot_less
loveless1168572loveless
mateless102711292mateless
moveless1367752moveless
nameless10248372nameless
natheless1244962natheless
nathless11127022nathless
netless739862net_less
noiseless945552noiseless
normless10235922normless
notedness1047322notedness
nounless837252nounless
poetless1038722poetless
poleless1089872poleless
popeless1288472popeless
soleless8910032soleless
toeless72612392to_eless
toneless8610392toneless
yokeless1535302yokeless
zoneless1737822zoneless
ageless8310343_ageless
artless73712513art_less
aweless1038723_aweless
baseless1099563baseless
bathless13127383bathless
blotless10347153blot_less
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boonless10328353boonless
bootless103410983bootless
botels84815803botel__s
bottlers103810013bottlers
bottles94216273bottle_s
bowelless1443833bowelless
bowless123310313bo_wless
careless102813633careless
cateress102311613cateress
clueless1035883clueless
coalless1038193coalless
coatless1039693coatless
cookless14258633cookless
cordless11299963cordless
costless10310003costless
cotterless1244033cotterless
coverless1436803coverless
coxless1637743co_xless
cureless10319703cureless
cuteness1039673cuteness
doneness9411513doneness
doorless936713doorless
dottles83912283dottle_s
dowerless1344013dowerless
downless1236363downless
edgeless1034883edgeless
eyeless1058053_eyeless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fatless103212203fat_less
feeless103511103_feeless
feetless1137383feetless
fireless112810593fireless
foamless13195843foamless
fogless1138193fo_gless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
fordless12289003fordless
forelegs1236613forelegs
forkless15267433forkless
formless13248083formless
fretless1138063fretless
fumeless13236603fumeless
fuseless11237233fuseless
goalless935723goalless
godless938403go_dless
goneness9310763goneness
gormless11235443gormless
grateless10277583grateless
groveless13235363groveless
gutless82610713gut_less
hatless103813443hat_less
hideless12278713hideless
hitless103211193hit_less
hiveless14227933hiveless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hornless1137363hornless
horseless1237223horseless
hostelers1246643hostelers
hoteliers1245813hoteliers
hotels94515523hotel__s
hotness1038613hot_ness
hotpress1344303hotpress
houseless1237473houseless
hueless1058823_hueless
iceless9219963_iceless
ireless72312243_ireless
isleless834853isleless
jobless16237563jo_bless
joyless17226513jo_yless
knockless1442443knockless
laceless10239853laceless
lateness82614073lateness
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
liteness82213213liteness
loamless10235213loamless
loftless1135903loftless
loneness8512093loneness
lordless9277483lordless
lossless835473lossless
maneless102812343maneless
matless93014043mat_less
modelers1138463modelers
moneyless1444653moneyless
moonless10278043moonless
moreness10911573moreness
motels83616903motel__s
motherless1544093motherless
motiles93317433motile_s
motiveless1542963motiveless
motleys1235683mot_leys
motorless1145723motorless
mottlers10388183mottlers
mottles93415803mottle_s
mouthless1444713mouthless
muteness1039013muteness
napless93110283n_apless
neckless14236433neckless
needless9308333needless
nerveless1243933nerveless
nettlers8307513nettlers
nettles73214083nettle_s
newsless1134533newsless
niceness1039843niceness
nobblers12318563nobblers
nobbles114014523nobble_s
nobleness1147523nobleness
nobles83319723no_ble_s
noblesse1044543no_blesse
noblest93613563no_blest
noctules1036583noctule_s
noddles92911293noddle_s
nodules8269703nodule_s
noels56418703no_el__s
nombles113212343nomble_s
nonclass1046243nonclass
nonelect10410283nonelect
nonetheless1451913nonetheless
noodles83513193noodle_s
nopales93812523nopale_s
nosiness83211393nosiness
notables10178243notable_s
notates72817483notate_s
notchers13279423notchers
notches123513653notche_s
notecase1044823notecase
notecases1145173notecases
notepads1143343notepads
noters64021003not__ers
notes55034583not__e_s
noticers1035703noticers
notices9312283notice_s
novelise1137953novelise
novelises1247373novelises
novelist1149453novelist
novelists1245933novelists
novellas1176343novellas
novels95512503novel__s
nowness1037033no_wness
nozzles15276303nozzle_s
nudeness936733nudeness
nutlets74111253nut_lets
oarless73913373_oarless
omelets938333_omelets
oneness7512143_oneness
orbless937493_orbless
outbless1037963outbless
paneless102611773paneless
pathless13138043pathless
pileless1088623pileless
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
plotless10256793plot_less
poetess938933po_etess
porteress1137933porteress
portless10310643portless
poteens92910883pote_ens
pottles93816983pottle_s
powerless1444293powerless
roadless937703roadless
rockless14297293rockless
rodless8310073ro_dless
roofless11316733roofless
rootless83910443rootless
ruleless836633ruleless
ruthless1135413ruthless
scoreless1155603scoreless
shoeless1137803shoeless
shoreless1236633shoreless
smokeless1543553smokeless
snowless1145633sno_wless
soapless10278073soapless
sockless14267793sockless
sodaless936113sodaless
soilless8279033soilless
soleness8814263soleness
songless9218823songless
sonless72612613so_nless
soreness8914793soreness
soulless8218763soulless
soupless10268463soupless
spotless1037043spot_less
stateless937563stateless
steles63725663_stele_s
stemless1036653_stemless
tameless10259903tameless
tapeless10218643tapeless
tasteless935673tasteless
teles54536003__tele_s
teleses7313123__teleses
telesis7310793__telesis
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toadless936313toadless
tombless1236783tombless
toolless836343toolless
toothless1244683toothless
topless92511123to_pless
townless1135653townless
toyless10268713to_yless
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
viceless1337983viceless
voiceless1444223voiceless
votaress1144223votaress
votress1035483vot_ress
vowless13246603vo_wless
wageless1237173wageless
wakeless1536473wakeless
waterless1238013waterless
wattless11268723wattless
waveless1437483waveless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
witless103310983wit_less
woeness1020211543wo_eness
woodless12278453woodless
wordless12258843wordless
workless15276803workless
worthless1544923worthless
yodelers1235673yodelers

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.453394461.4
2DLD Change Limit1461622747.78318779.6
3Display Results2742740.1062584.9
 (SQL Overall)1786912748.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.