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

245 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
apathy143703(None) 
apache134210772apache
aphtha1444482aphtha
aptly105111812ap_tly
deathy134210232deathy
empathy1743482empathy
heathy156111212heathy
lathy115215062_lathy
patchy16509572_patchy
path99134912_path_
paths105521382_paths
patly105020582_patly
patsy105717202_patsy
patty104723612_patty
paty95234562_pat_y
pithy135614462_pithy
spathe115115692spathe
wrathy15377852wrathy
aah616252963a_a_h_
aahs716428563a_a_hs
abash106016513abash_
abate76627843abat_e
abated95918453abated
abater85518123abater
abates85825033abates
abatis84317933abatis
abator84512713abator
acantha1254653acantha
acanthi1244663acanthi
achy126316093__achy
agate66525143agat_e
agates76121333agates
airth85621023airth_
airths95414253airths
alary86123443ala_ry
alate55340323alat_e
alated75625143alated
alates64833963alates
allopathy1753643allopathy
altho86312603a_ltho
amah98927483ama_h_
amahs107819063ama_hs
amatol838683amatol
amatory1238613amatory
amity10416083amit_y
anally9513503anally
anarchy1544933anarchy
anatomy1246233anatomy
anatto6139913anatto
antipathy1745083antipathy
antsy85712793a_ntsy
apace94718383apa_ce
apaches143411833apaches
apart74330673apa_rt
apathies1339003apathies
apatite9312963apatite
apery106517903ap_ery
apetaly1237253apetaly
aphthae1544703aphthae
apiary113910383apiary
apish105116633apish_
apishly1535663apishly
apothem1444633apothem
apply125111393ap_ply
apt57352543ap_t__
apter76120203ap_ter
artsy86012963a_rtsy
arty77531313a_rt_y
ashy107717353__ashy
ataxy1537313ata_xy
auntly95211063auntly
aunty85919813aunt_y
avatar937523avatar
awash116613163awash_
away108024223awa__y
ayah108022993aya_h_
ayahs116813523aya_hs
azoth17389903azoth_
azoths18366203azoths
bath95940083_bath_
bathe105822883_bathe
baths105922923_baths
batty105422243_batty
beachy164011253beachy
bothy136713963_bothy
brashy145210593brashy
bratty1159683bratty
breathy15328033breathy
brothy14519623brothy
bypath1645353bypath_
bypaths1743193bypaths
calathi1247573calathi
capably1639253capably
catchy16559583_catchy
catty104520413_catty
chatty14419363chatty
dashy125612383_dashy
death94822523death_
deathly14336863deathly
deaths105914443deaths
earthy12399943earthy
eath75735663_eath_
eparchy17204753eparchy
fatly115716803_fatly
fatty115117413_fatty
featly123711753featly
filthy15356423filthy
flashy15498173flashy
flatly123110213flatly
frothy15578373frothy
gnatty10336483gnatty
hath105933913_hath_
healthy16416083healthy
heath115724283heath_
heaths126316383heaths
lath76640383_lath_
lathe85626713_lathe
lathi85417203_lathi
laths86022403_laths
leachy14419733leachy
loath84918603loath_
loathe94211383loathe
loathly1334713loathly
mashy136016503_mashy
matey107022663_matey
math95437443_math_
maths105624023_maths
meaty107021313meat_y
mothy136214553_mothy
mouthy14409063mouthy
myopathy2143113myopathy
mythy16568673_mythy
naphtha1542923naphtha
naphthyl1951633naphthyl
natty85719143_natty
neath86020283neath_
neatly93812483neatly
oath76132153_oath_
oaths86117313_oaths
opah96218403opa_h_
opahs105411983opa_hs
pacey126720283_pacey
pacha126518063_pacha
pacy115328683_pa_cy
paddy125913593_paddy
pah88853593_pa_h_
pally105727123_pally
palmy126016733_palmy
palsy105417463_palsy
paltry114910403paltry
paly95835533_pa_ly
pandy115021173_pandy
pansy105717973_pansy
pantry115014103pantry
panty105929303_panty
papacy1547493papa_cy
papally1437973papally
pappy114713803_pappy
pardy115523953_pardy
parry105323753_parry
partly116315473partly
party106630613_party
pash95638133_pash_
pasha105417183_pasha
pastry114913033pastry
pasty105725053_pasty
pat58089463_pat__
patch125221223_patch
pate65350463_pat_e
pated85237843_pated
paten74827343_paten
pater74740723_pater
pates76047893_pates
pathos115516693_pathos
pathway1844853_pathway
patin76832853_patin
patio74426353_patio
pats66460853_pat_s
pawky173810153_pawky
pay88461183_pa__y
peachy164510843peachy
peaty105725693peat_y
petty105320293_petty
pitchy16479673_pitchy
pith95432693_pith_
piths105817543_piths
pity96031933_pit_y
plashy14448873plashy
platy105021663plat_y
poachy16388963poachy
potsy105815613_potsy
potty105621003_potty
pushy134614353_pushy
putty104721403_putty
raptly11338913rap_tly
rath76037663_rath_
rathe85821923_rathe
ratty84819593_ratty
satay84718463_satay
scathe114414993scathe
scatty115310653scatty
slatey95417063slatey
slaty86523153slat_y
smithy14508273smithy
snatchy15355293snatchy
snath86419803snath_
snathe94415113snathe
snaths95112913snaths
spacey136212533spacey
spacy125415623spa_cy
spahi10311143spa_hi
sparky154511523sparky
sparry115111303sparry
spat66548523spat__
spate74731583spat_e
spates85028173spates
spathal1236263spathal
spathed134013183spathed
spathes125116533spathes
spathic1437523spathic
spats75031383spat_s
spay96631663spa__y
splashy1543553splashy
spotty11448573spotty
stithy12398213stithy
swarthy16466373swarthy
swath115920383swath_
swathe125514113swathe
swaths125312643swaths
sympathy2143593sympathy
tatty84720183_tatty
thatchy1833303thatchy
thy97022913___thy
toothy12529693toothy
trashy12509053trashy
warpath1545203warpath_
warpaths1643973warpaths
washy145911843_washy
wealthy16314333wealthy
withy144813763_withy
worthy15598803worthy
wrath115715873wrath_
wraths123810083wraths
wreathy16326063wreathy
zapateo1844593zapateo

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162456.54617219.1
3Display Results2452450.0803062.5
 (SQL Overall)1786912456.76626410.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.