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

183 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
nathless1112702(None) 
bathless13127381bathless
natheless1244961natheless
pathless13138041pathless
ashless10318452_ashless
cashless1336772cashless
dateless9259962dateless
deathless1335222deathless
faithless1543902faithless
fatless103212202fat_less
gateless9279952gateless
hatless103813442hat_less
heathless1535592heathless
matchless1644682matchless
mateless102711292mateless
matless93014042mat_less
nameless10248372nameless
napless93110282na_pless
netless739862net_less
noteless839402noteless
pithless13117022pithless
ruthless1135412ruthless
sashless1136602sashless
wattless11268722wattless
ageless8310343_ageless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
anthems12309423anth_ems
anthers103715203anth_ers
antheses11311473anth_eses
anthesis11312503anth_esis
antlers74014743ant_lers
armless9369943_armless
artless73712513_artless
ashlers10319583_ashlers
athlete1068083_athlete
athletes1157883_athletes
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
barbless12318713barbless
barkless14318023barkless
barless94317003ba_rless
baseless1099563baseless
bathers124720363bath_ers
bathes116524833bath_e_s
bathoses13310463bathoses
battlers104110973battlers
battles94517683battle_s
beatless103311593beat_less
breathless1543533breathless
bushless1335813bushless
capless114312763ca_pless
careless102813633careless
carless95118493ca_rless
cateress102311613cateress
coatless1039693coat_less
depthless1542753depthless
earless74316073ea_rless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fangless1237663fangless
fatalness1245773fatalness
fatherless1644213fatherless
fathers133916503fath_ers
fathomless1842003fathomless
fatness103311293fat_ness
fishless1436413fishless
gainless9117403gainless
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
gathers114315073gath_ers
grateless10277583grateless
gutless82610713gut_less
hairless1157413hairless
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
harmless1337403harmless
heatless113011463heat_less
hitless103211193hit_less
jagless1537103ja_gless
jawless1745653ja_wless
knotless1264563knot_less
laceless10239853laceless
landless94011173landless
lateness82614073lateness
lathers104321883lath_ers
lathes95127493lath_e_s
lathiest11312653lathiest
lawless1037033la_wless
loathness1244703loathness
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
matiness102114753matiness
mattress1036533mattress
meatless103410863meat_less
mirthless1443353mirthless
mouthless1444713mouthless
nabobess1242203nabobess
naches114622413nach_e_s
nailers73215893na_ilers
naleds7469133na__leds
nastiness92310573nastiness
nates55238333nat__e_s
natives10310823native_s
natters73718063nat_ters
nattiest83215353nattiest
nattiness9239333nattiness
natures7311963nature_s
neatness839153neat_ness
neckless14236433neckless
needless9308333needless
nettlers8307513nettlers
nettles73214083nettle_s
newsless1134533newsless
nighness1236103nighness
nightless1386073nightless
normless10235923normless
noseless839513noseless
nounless837253nounless
nutlets74111253nut_lets
oarless73913373oa_rless
outbless1037963outbless
painless10108343painless
paneless102611763paneless
passless10247223passless
pastless102411203pastless
pathoses13412773pathoses
patness92912283pat_ness
pitiless10127333pitiless
rainless8129703rainless
ranchless1444453ranchless
rankless12268233rankless
rashness1138093rashness
ratholes11312413rathole_s
rattlers83510293rattlers
rattles73217303rattle_s
rayless10239003ra_yless
sailless82410373sailless
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
scatheless1542923scatheless
seatless83213003seat_less
sighless1276553sighless
snapless10287463sna_pless
snathes104816493snath_e_s
starless81610843starless
stateless937563stateless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tasteless935673tasteless
tattlers8369693tattlers
tattles73616283tattle_s
taxless1436903ta_xless
teethless1243703teethless
toothless1244683toothless
truthless1244033truthless
voteless1137493voteless
wageless1237173wageless
wakeless1536473wakeless
wardless12249303wardless
warless104015103wa_rless
wartless11279923wartless
waterless1238013waterless
wattles103814073wattle_s
waveless1437483waveless
wayless13308243wa_yless
wishless1435993wishless
witless103310983wit_less
worthless1544923worthless

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.1531167915.0
2DLD Change Limit1461621837.80018738.7
3Display Results1831830.0762407.9
 (SQL Overall)1786911838.02922255.7
 
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.