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

238 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
deffest1430880(None) 
deafest112911511deafest
deftest112611711deftest
buffest15298642buffest
daffiest1537842daffiest
daftest11248942daftest
deadest93014882deadest
dearest83618672dearest
deepest10310442deepest
defeat103817162de_feat
defect124816172de_fect
deffer134411302deffe_r
defies104624052defies_
deflect13399972deflect
deforest1238792deforest
defrost1139552defrost
densest83112472densest
detest74122842de_test
devest104418702de_vest
dewiest11312342dewiest
effect1437442_effect
leftest10269462leftest
adeptest1145453adeptest
aeriest73924053aeriest
affect1448903_affect
bedfast1346413bedfast
beefiest13269013beefiest
befret11315963befre_t
befrets1237613befrets
behest11314613be_hest
bequest1837823bequest
bluffest1664643bluffest
buffet143113783buffe_t
buffets15317593buffets
buffiest1657563buffiest
chuffest1944193chuffest
coeffect1843933coeffect
daffed14429493daffe_d
daffs125116423daff_s_
dampest12411043dampest
dankest122611673dankest
darkest122512623darkest
deafen10389673deafe_n
deafens11317253deafens
deafer104114813deafe_r
deafish1438533deafish
deafness1236213deafness
deaves105319533deaves_
debyes1238103debyes_
deceit93018213de_ceit
decent94023703de_cent
deediest102912253deediest
dees56356633de__es_
deet57356583de__e_t
deets65330243de__ets
defaces133213403defaces_
defames132812253defames_
defat95426693de_f_at
defats105114553defats_
default1147893default
defeats113511233de_feats
defects134511523de_fects
defend113910493de_fend
defense1137503defense
defer94619753de_fe_r
deferent122712873deferent
defers105116943de_fers
defiant11311923defiant
deficit1339673deficit
defied115016383defie_d
defier105118653defie_r
defiers113913993defiers
defiles114016843defiles_
defines114118683defines_
defis96717503de_fis_
deflea1037443defle_a
defleas1147223defleas
deflects14336733deflects
defogs1156683defogs_
deforests1344373deforests
defrosts1244833defrosts
deft85540223de_f__t
defter104215923defte_r
deftness1236303deftness
defuel10348933defue_l
defuels11296983defuels
defunct1345773defunct
defuse105712723de_fuse
defused125211093defused
defuser115110503defuser
defuses114814593defuses
defuzes20398303defuzes_
degust8310253de_gust
deices94119373deices_
deifies113317453deifies_
deist64633593de__ist
deject164512843de_ject
dekes105224453de_kes_
deles65139253de_les_
delfs94918673delf_s_
delft95623323delf__t
delfts10439673delfts_
delist74625053de_list
delves104917083delves_
demast9517063de_mast
dement93825153de_ment
demes86032693de_mes_
demies94825803demies_
demurest1137453demurest
denes65639723de_nes_
denies74729643denies_
dentist8316743dentist
depress10239873depress
descent102616293descent
desert72725493de_sert
desist74818813de_sist
dessert82916453dessert
detect94217403de_tect
detent73624483de_tent
detests83711743de_tests
deuces94015513deuces_
devests114410473de_vests
dewless1137473dewless
dexes135224513de_xes_
dexies145018343dexies_
diciest103316523diciest
differ133910843diffe_r
differs14339973differs
diffs126315483diff_s_
diffuse1444373diffuse
digest84019623d_igest
dimmest1249253dimmest
direst75024243d_irest
divest106820073d_ivest
doest65829523d__oest
doffed14428503doffe_d
doffer133911353doffe_r
doffers14359853doffers
doffs125614333doff_s_
dopiest103315993dopiest
dotiest83717453dotiest
dourest8312943dourest
doziest174012473doziest
draffiest1644363draffiest
drest65530343d__rest
driest74722753d_riest
dryest104811123d_ryest
duffel13407753duffe_l
duffels14296453duffels
duffer134711663duffe_r
duffers143410093duffers
duffles14308923duffles_
duffs125216623duff_s_
dullest8312633dullest
dumbest1238743dumbest
dunnest83312263dunnest
dwarfest1543473dwarfest
edgiest92310353edgiest
eeliest73516473eeliest
eeriest73620673eeriest
effects1535283_effects
effete1235183_effete
effort1238623_effort
effs105114033_eff_s_
effuse1234963_effuse
egest65222343_e_gest
eldest72912683_eldest
featest102715113featest
fellest10313753fellest
fest74949443___fest
fewest12311663fe_west
feyest12311403fe_yest
funfest13348083funfest
gabfest1336453gabfest
gaffes134811103gaffes_
geest64829623ge__est
gruffest1544593gruffest
haffet15311703haffe_t
haffets1636053haffets
heftiest1439183heftiest
heppest14228153heppest
huffiest1757203huffiest
iffiest1337963iffiest
infest93315433_infest
jefes155613673je_fes_
keenest11410963keenest
leafiest113410893leafiest
leanest7415863leanest
leftist10279353leftist
lewdest1136283lewdest
liefest1038443liefest
meanest9315703meanest
meekest1336893meekest
merest84725113me_rest
miffiest1637133miffiest
nearest73415843nearest
neatest72516003neatest
newest9314213ne_west
offset1238373_offset
oftest91212003_oftest
perfect141010833perfect
pertest9317043pertest
puffiest1647323puffiest
realest73322433realest
reddest9311953reddest
reefiest112811483reefiest
reest54938093re__est
refect114319333re_fect
refelt94521423re_felt
reffed134712513reffe_d
reflect123913713reflect
reflet94024233refle_t
reflets103513153reflets
reforest1139963reforest
refresh1335453refresh
renest64529713re_nest
request16311023request
retest64028453re_test
revest94623603re_vest
rifest93114583_rifest
ruffes124112423ruffes_
safest95016603_safest
searest73322023searest
serest64831613se_rest
sexiest142112223sexiest
softest10310603softest
stiffest1435683stiffest
teffs115111733teff_s_
tempest1139223tempest
tensest72713313tensest
tersest71713993tersest
tuffet122612083tuffe_t
tuffets13266523tuffets
veriest103719133veriest
weakest1439003weakest
webfeet1544593webfeet
weest85026773we__est
wettest10239363wettest

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 Limit1340272385.82623005.0
3Display Results2382380.0932559.1
 (SQL Overall)1786912386.32528251.5
 
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.