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 “bathless” 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
bathless1312738(None) 
nathless11127021nathless
pathless13138041pathless
ashless10318452_ashless
backless162910632backless
barbless12318712barbless
barkless14318022barkless
barless94317002ba_rless
baseless1099562baseless
bathers124720362bath_ers
bathes116524832bath_e_s
bathoses13310462bathoses
battlers104110972battlers
battles94517682battle_s
beatless103311592beat_less
breathless1543532breathless
bushless1335812bushless
cashless1336772cashless
dateless9259962dateless
deathless1335222deathless
faithless1543902faithless
fatless103212202fat_less
gateless9279952gateless
hatless103813442hat_less
heathless1535592heathless
matchless1644682matchless
mateless102711292mateless
matless93014042mat_less
natheless1244962natheless
pithless13117022pithless
ruthless1135412ruthless
sashless1136602sashless
wattless11268722wattless
ageless8310343_ageless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
armless9369943_armless
artless73712513_artless
ashlers10319583_ashlers
athlete1068083_athlete
athletes1157883_athletes
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
babblers113510353babblers
babbles104416323babble_s
baches135426943bach_e_s
badgeless1343203badgeless
badness1039573ba_dness
bafflers16356593bafflers
baffles153710683baffle_s
bailees93914383ba_ilees
bailers94221353ba_ilers
baileys12388933ba_ileys
baldness1137043baldness
balers85626933ba__lers
bales76250083ba__le_s
ballers94421013ba_llers
ballets93719513ba_llets
bangles103617413bangle_s
bareness10912813bareness
barleys125011843ba_rleys
baroness101210063baroness
baseness10910943baseness
bashers124820833bash_ers
bashes115631393bash_e_s
bashlyks2041973bashlyks
bassness1096743bassness
bastiles10313353bastile_s
batchers153613273batchers
batches144019613batche_s
bates75846343bat__e_s
bathe105822883bath_e__
bathed125518743bath_e_d
bather115322513bath_e_r
bathmats1545933bathmats
bathos116215633bath__os
baths105922923bath___s
bathtubs1541883bathtubs
battens95313263bat_tens
batters94626013bat_ters
battiest104115553battiest
battiness11239843battiness
battle85217863battle__
battled104213123battle_d
battler94113383battle_r
battues94610193battue_s
baubles113611863bauble_s
bawlers124412733ba_wlers
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
bedless1039703b_edless
beefless1335493beefless
beltless10297713beltless
benchless1644153benchless
bethels1238533beth_els
biathlete1442793biathlete
biathletes1552693biathletes
biathlons14103333biathlons
bibless11439173b_ibless
bladeless1234303bladeless
blameless1334733blameless
blathers134713793blath_ers
bless75917813b___less
blotless10347153blotless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boonless10328353boonless
bootless103410983bootless
bothers124317753both_ers
bothies12414783bothie_s
bottlers103810013bottlers
bottles94216273bottle_s
boughless1543873boughless
bowless123310313b_owless
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
braless92910563b_raless
branchless1743303branchless
brandless1236123brandless
brashness1436323brashness
brattles10199333brattle_s
brimless1235273brimless
browless1346653browless
brushless1444003brushless
budless1038873b_udless
butchness1643453butchness
butlers94518053but_lers
butles84423913but_le_s
buttress1035883buttress
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
laceless10239853laceless
landless94011173landless
lateness82614073lateness
lathers104321883lath_ers
lathes95127493lath_e_s
lathiest11312663lathiest
lawless1037033la_wless
loathness1244703loathness
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
matiness102114753matiness
mattress1036533mattress
meatless103410863meat_less
mirthless1443353mirthless
mouthless1444713mouthless
nameless10248373nameless
napless93110283na_pless
netless739863net_less
noteless839403noteless
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
starless81610843starless
stateless937563stateless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tasteless935673tasteless
tattlers8369693tattlers
tattles73616283tattle_s
taxless1436913ta_xless
teethless1243703teethless
toothless1244683toothless
truthless1244033truthless
voteless1137493voteless
wageless1237173wageless
wakeless1536473wakeless
wardless12249303wardless
warless104015103wa_rless
wartless11279923wartless
waterless1238013waterless
wattles103814073wattle_s
waveless1437483waveless
wayless13308243wa_yless
wishless1435993wishless
witless103310983wit_less
worthless1544923worthless

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.406440125.6
2DLD Change Limit1461622426.71621763.3
3Display Results2422420.1102200.0
 (SQL Overall)1786912427.23224708.4
 
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.