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

241 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
pathless1313804(None) 
bathless13127381bathless
nathless11127021nathless
pithless13117021pithless
ashless10318452_ashless
cashless1336772cashless
dateless9259962dateless
deathless1335222deathless
faithless1543902faithless
fatless103212202fat_less
gateless9279952gateless
hatless103813442hat_less
heathless1535592heathless
matchless1644682matchless
mateless102711292mateless
matless93014042mat_less
natheless1244962natheless
painless10108342painless
paneless102611762paneless
passless10247222passless
pastless102411202pastless
pathoses13412772pathoses
patness92912282pat_ness
pitiless10127332pitiless
ruthless1135412ruthless
sashless1136602sashless
wattless11268722wattless
ageless8310343_ageless
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
apathies1339003apathie_s
aptness9268573apt_ness
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
laceless10239853laceless
landless94011173landless
lateness82614073lateness
lathers104321883lath_ers
lathes95127493lath_e_s
lathiest11312653lathiest
lawless1037033la_wless
loathness1244703loathness
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
matiness102114753matiness
mattress1036533mattress
meatless103410863meat_less
mirthless1443353mirthless
mouthless1444713mouthless
nameless10248373nameless
napless93110283na_pless
netless739863net_less
noteless839403noteless
oarless73913373oa_rless
outbless1037963outbless
packness1636933packness
paddlers12329153paddlers
paddles113515643paddle_s
padles95221123pa_dle_s
paisleys1333343paisleys
paleness10312983paleness
pales75753803pa__le_s
palest83926223pa__lest
palets85122313pa__lets
pallets93919303pa_llets
pamphlets1842753pamphlets
pantalets1147673pantalets
pantdress1243363pantdress
panthers13510783panth_ers
pantiles103617153pantile_s
paperless1345833paperless
papules112411573papule_s
parflesh1643743parflesh
parles86334403pa_rle_s
parleys125212373pa_rleys
parolees104313973parolees
paroles95025883parole_s
parsleys1335083parsleys
partlets102811513partlets
pashes115828393pash_e_s
pastiness112312353pastiness
pastness102510503pastness
patchers153413303patchers
patches143320383patche_s
patchiest1638353patchiest
patchiness1744933patchiness
patellas1039103patellas
patens84820863pat__ens
paters84935833pat__ers
pates76047893pat__e_s
pathogens1545713pathogens
pathos115516693path__os
paths105521383path___s
pathways1944273pathways
patines95225763patine_s
patroness1137483patroness
patsies93919483patsie_s
pattens95414923pat_tens
patters94825193pat_ters
patties93425143pattie_s
patulent1048603patulent
patulous10116363patulous
patzers184210573pat_zers
peakless14236683peakless
peerless1037513peerless
pegless1038053p_egless
peltless10267373peltless
pettles93916483pettle_s
phthises1645723phthises
pileless1088623pileless
pipeless12107663pipeless
pithiest132711443pithiest
pithiness1437563pithiness
placeless1335613placeless
planless1036813planless
platelets1165763platelets
playless1334863playless
pleatless1134613pleat_less
plotless10256793plotless
plugless1133863plugless
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
portless10310643portless
poshness1356653poshness
potheens13266483potheens
pothers123818623poth_ers
potholes13312933pothole_s
pottles93816983pottle_s
prattlers11195323prattlers
prattles10189403prattle_s
prebless1236823prebless
pulpless12224953pulpless
pumpless14236373pumpless
punchless1643653punchless
puttyless1442013puttyless
pythoness1743733pythoness
rainless8129703rainless
ranchless1444453ranchless
rankless12268233rankless
rashness1138093rashness
ratholes11312413rathole_s
rattlers83510293rattlers
rattles73217303rattle_s
rayless10239003ra_yless
sailless82410373sailless
saltless8259343saltless
sandless93212343sandless
sapless93313443sa_pless
scatheless1542923scatheless
seatless83213003seat_less
sighless1276553sighless
spaceless1335733spaceless
spanless10247363spa_nless
spathes125116533spath_e_s
spatzles1935303spatzle_s
spotless1037043spot_less
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.1561145455.1
2DLD Change Limit1461622417.89018525.0
3Display Results2412410.0932591.4
 (SQL Overall)1786912418.13921954.9
 
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.