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

110 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
epithet1231246(None) 
epithets1345761epithets
either94517422e_ither
epithetic1666412epithetic
pithed124615612_pithed
apothem1444643apothem
blithe115810863blithe_
blither124812173blither
blithest1338083blithest
cither114616683_cither
dither104417683_dither
earthed1139923earthed
earthen1039253earthen
earthset11410823earthset
edited83913673edit_ed
eight94928053e_igh_t
elite56230183elit_e_
elites66027123elit_es
elitist7414913elitist
emitted103010853emitted
emitter93211083emitter
epaulet939513epaulet
epidote1037393epidote
epilate9314283epilate
epimer10109153epi_mer
epiphyte1843803epiphyte
epistle957893epistle_
epistler1044833epistler
epistles1047783epistles
epitaph1444133epitaph
epitases1038933epitases
epitaxy1963563epitaxy
epithelia1444743epithelia
epitome1157743epitome
epitomes1257713epitomes
epitope1147053epitope
epitopes1246973epitopes
esthete1047433e_sthete
ether84518773e__ther
evite85317683evit_e_
evited104013143evit_ed
evites94916473evit_es
exited144712523exit_ed
faithed1437163faithed
fitchet153113563_fitchet
hither124417253_hither
ither84617603__ither
kithe125917453_kithe_
kithed144613013_kithed
kithes135016653_kithes
lithe84922013_lithe_
lither94520953_lither
lithest10513913_lithest
mither114218563_mither
neither1037573neither
picket144924313_picket
piglet93420923_piglet
piolet83225643_piolet
pipet95533323_pi_pet
piquet17412353_piquet
pished124817063_pished
pisher114317753_pisher
pishes114722103_pishes
pitched153512923_pitched
pitcher143813713_pitcher
pitches143617753_pitches
pith95432693_pith__
pithead13419593_pithead
pithier123010293_pithier
pithiest132711443_pithiest
piths105817543_pith_s
pithy135614463_pith_y
pitied94017253_pitied
pitier84019823_pitier
pities83828083_pities
pitmen102510793_pitmen
pitted94319593_pitted
pother113818853_pother
prithee1239933prithee
saithe94713913saithe_
septet8921133sep_t_et
slither104112983slither
spathe115115693spathe_
spathed134013183spathed
spathes125116533spathes
spinet85629753spi_net
spite75430663spit_e_
spited94820443spit_ed
spites84127333spit_es
spitted103912703spitted
spitter94015183spitter
spitzes1849183spitzes
swithe124010683swithe_
swither133710993swither
thither13328103thither
tithe85319703_tithe_
tithed104115593_tithed
tither94920283_tither
tithes94720213_tithes
whither163510253whither
withe115220233_withe_
withed134416233_withed
wither124321353_wither
withes124620843_withes
writhe125310703writhe_
writhed14389623writhed
writhen13407863writhen
writher134010853writher
writhes134811703writhes
zither183813083_zither

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271106.36021073.4
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.81226231.8
 
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.