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

117 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
apathies133900(None) 
apaches143411832apach_es
apatites10311292apatites
empathies16115402empathies
patsies93919482_patsies
patties93425142_patties
spathes125116532spath_es
abashes12510373abash_es
abates85825033abat__es
abatis84317933abat_i_s
abatises10311013abatises
abattis9297823abatti_s
abattises1155083abattises
agates76121343agat__es
agatizes1838863agatizes
alates64833963alat__es
allopathies1653743allopathies
amities9317383amit_ies
anarchies1448183anarchies
anatases839793anatases
anatomies11159693anatomies
antipathies1655373antipathies
apache134210773apach_e_
apagoges12144693apagoges
apanages1137013apanages
apartheid1543553apartheid
apartheids1652363apartheids
apathy1437033apath__y
apatite9312963apat_ite
aperies9423203ap_eries
apetalies1148003apetalies
aphides134711203ap__hides
aphids125110843ap__hids
aphis105917133ap__hi_s
aphthae1544703aphthae_
aphthous1694873aphthous
apiaries10312723apiaries
apotheces1644013apotheces
apothem1444643apoth_em
apothems1544223apothems
applies11311213ap_plies
ataxies142410013ata_xies
aunties73920073aunt_ies
bathes116524833_bath_es
bothies12414783_bothies
catties94023053_catties
empathise1684183empathise
empathises17104063empathises
empathizes2673443empathizes
eparchies1646973eparchies
fatties103018203_fatties
gnathites1344233gnathites
heathier1438343heathier
heathiest1549383heathiest
lathes95127493_lath_es
lathier10310833_lathier
lathiest11312653_lathiest
lathis95516173_lathi_s
loathes103513243loath_es
mashies12318253_mashies
myopathies2053973myopathies
paddies113715723_paddies
palsies94420273_palsies
pandies104224503_pandies
pansies94521983_pansies
panties94230933_panties
pantries101817393pantries
papacies1439473papa_cies
pappies103214823_pappies
paries84742513_pa_ries
parries93925843_parries
parties93230863_parties
pashes115828393_pash_es
pasties94529813_pasties
pastries101517423pastries
patches143320383_patches
patchier15319663_patchier
patchiest1638353_patchiest
pates76047893_pat__es
pathless13138043_pathless
pathos115516693_path_os
pathoses13412773_pathoses
paths105521383_path__s
patines95225763_patines
patins87528783_pat_ins
patios85221783_pat_ios
patois84319363_patoi_s
pattie84020963_pattie_
phthises1645723_phthises
pithier123010293_pithier
pithiest132711443_pithiest
pities83828083_pit_ies
platies93722543plat_ies
potpies113116173_potpies
potsies93019483_potsies
potties93723543_potties
putties94420023_putties
scathes124515713scath_es
smithies1337913smithies
snathes104816493snath_es
spahees1238263spa_hees
spahis11310383spa_hi_s
spates85028173spat__es
spathe115115693spath_e_
spathed134013183spath_ed
spathic1437543spathi_c
spathose1345633spathose
spatzles1935303spatzles
spavies123012943spa_vies
stithies1139233stithies
swathes134115513swath_es
sympathies2054583sympathies
tatties74120343_tatties
withies133913543_withies
worthies14310283worthies
wrathier1435903wrathier
wrathiest1536973wrathiest

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.423422437.4
2DLD Change Limit1461621176.59322169.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.06225303.2
 
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.