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

270 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
fescues123678(None) 
fescue1137491fescue_
rescues9312751rescues
fasces114914542fasc_es
feces105625362fe_c_es
fences114617112fenc_es
fesses94820252fes_ses
fetches153413892fetches
frescoes1357832frescoes
miscues11312392miscues
rescue8313002rescue_
rescued10410042rescued
rescuer939032rescuer
rescuers1037362rescuers
ascus75013583_ascu_s
bascules1236683bascules
basques18248673basques
beaches144120653beaches
beeches143413883beeches
belches143514343belches
benches143918603benches
bescours1245093bescours
beses75830723bes__es
besides104814533besides
besmuts1134683besmuts
bestuds10326753bestuds
bisques18236893bisques
bosques18217973bosques
casques18278983casques
cercus105013153cercu_s
cesiums1136303cesiums
cesses84221363ces_ses
cestus84412913cestu_s
cestuses1038083cestuses
ciscoes113610733ciscoes
cues65438983___cues
cuscus1038113cuscu_s
cuscuses1235863cuscuses
deduces1168793deduces
deices94119373deic_es
dengues938183dengues
descries11311923descries
desexes1537833desexes
desires81316133desires
deuces94015513deuc_es
discus94512113discu_s
discuses113112863discuses
discuss10357953discuss
eches106322163_e_ches
ecus65421463_e_cu_s
educes94011953_educes
emcees1037813_emcees
endues73813903_endues
ensues63313813_ensues
escapes113811673_escapes
escars83913133_escars
eschew1436333_eschew
eschews1534553_eschews
escots84211743_escots
escuages1145163_escuages
escudo943373_escudo
escudos1043493_escudos
eses45336103_es__es
esnes54817363_es_nes
espies83716803_espies
esses56422973_es_ses
etches114217763_etches
excuse1537423_excuse
excuses1638903_excuses
faces106439433f_ac_es
facies113921593f_acies
faeces114713123faec_es
falces115216003falc_es
fancies124018783fancies
farces115223323farc_es
farcies125317883farcies
fascias1258413fascias
fascines13310143fascines
fashes124524023fas_hes
fauces114916153fauc_es
feases95422923fe_ases
features11310333features
feazes184514173fe_azes
fecks145417853fe_c_ks
fecula113310053fe_cula
fecund1235433fe_cund
fedexes1835473fedexes
fees76450603fe___es
feezes184412613fe_ezes
felines104718073felines
fellies104119743fellies
felloes104114383felloes
felsites1138073felsites
females12310663females
femes105626223fe__mes
femmes135410213fe_mmes
femurs1136713fe_murs
fence105319913fenc_e_
fenced124412713fenc_ed
fencer114613533fenc_er
fencers123810623fencers
feres86038183fe__res
ferlies103216693ferlies
ferries103521083ferries
ferrules1136163ferrules
ferrums1265983ferrums
ferules103112723ferules
fess76529163fes___s
fesse86116333fes_se_
fessed104515063fes_sed
fester94723513fes_ter
festers104121393festers
fests85828043fes__ts
fetched163710473fetched
fetcher153510393fetcher
fetchers16328863fetchers
fetes85630143fe__tes
fetiches1636953fetiches
fettles103912733fettles
fetus85816543fe_tu_s
fetuses10310243fetuses
feuds95914883fe__uds
feued94715663fe__ued
feus75830753fe__u_s
fezes175220023fe__zes
fezzes174910403fe_zzes
fiacres1237253fiacres
fiascoes13134923fiascoes
fices106031163f_ic_es
fiches145219533f_iches
ficoes114613463f_icoes
ficus105015493f_icu_s
ficuses12159203f_icuses
filches153410723filches
finches153914193finches
fiques1837973f_iques
fiscals1238003fiscals
fiscs105311883fisc__s
fishes125221343fis_hes
fissures1136573fissures
fitches153516193fitches
fleches153411443fleches
fleeces12399643fleec_es
fleeches16287083fleeches
flenches163410533flenches
fleshes133913273fles_hes
fletches16308853fletches
flues84626923f__lues
flysches1933123flysches
focus105815883f_ocu_s
focuses12159653f_ocuses
fondues11399313fondues
forces114422133forc_es
fosses96022083fos_ses
frenches163311633frenches
frescoed1436053frescoed
frescoer1345983frescoer
frescoers1454563frescoers
frescos1236813fresc_os
freshes133515823fres_hes
fucus105515893f_ucu_s
fucuses12158353f_ucuses
fugues104511683f_ugues
fuscous1256673fuscous
fusees95416403fus_ees
fuses85628423fus__es
fusses94920553fus_ses
fyces139813643f_yc_es
gessoes838293gessoes
gestes75721393ges_tes
gestures9310013gestures
hercules1337633hercules
issues648803_issues
jesses135215953jes_ses
kenches163912273kenches
ketches164012193ketches
leaches123319343leaches
leagues837943leagues
leches115421313le_ches
leeches123911933leeches
leses54930813les__es
lessees73510243lessees
letches124015483letches
masques18239363masques
mensches1536303mensches
merces105720743merc_es
merches144013763merches
mercies113817563mercies
mescals112911563mescals
mescluns1243343mescluns
meshes115019443mes_hes
mesnes85216213mes_nes
messes84924343mes_ses
mestees94617753mestees
miscue10412223miscue_
miscued1239293miscued
miscuts1139183miscuts
mosques18256913mosques
muscles11310563muscles
nesses64718323nes_ses
nestles73015463nestles
obscures1245513obscures
oscules938123_oscules
peaces106324083peac_es
peaches144120053peaches
perches143717953perches
percuss1137163percuss
perdues103511333perdues
pesades10310903pesades
pestles93217693pestles
reaches123423203reaches
recces10614913re_cces
recurs83315803re_curs
recuse85519163re_cuse
recuses94619463re_cuses
recuts83817373re_cuts
reduces10513343reduces
reglues838713reglues
reissues845993reissues
resales74724903resales
rescales103414573rescales
rescores105415693rescores
resecures1146733resecures
resees63827483res_ees
reshes94124363res_hes
reshoes102316033reshoes
resides84523283resides
residues9338813residues
resiles74026543resiles
resites74027793resites
resizes164216843resizes
resoles73823653resoles
resumes9313373resumes
retches123318513retches
revues9813903re_vues
roscoes9310923roscoes
scuds85116243__scuds
scums95017423__scums
scups95316653__scups
scutes85219193__scutes
scuts74522523__scuts
secures9613163se_cures
seduces1069283seduces
segues7412073se_gues
seiches12513813seiches
sesames9310743sesames
slues54527173__slues
spues75025383__spues
sues46247653__s_ues
teaches122718353teaches
teacups1133963teacups
tenches123515523tenches
tenues63816443te_nues
terces83921413terc_es
testees74215913testees
testes65125823tes_tes
tissues737463tissues
tusches1237903tusches
usques15126803_usques
vendues11318623vendues
venues95115203ve_nues
vesicles13127073vesicles
vestees103513173vestees
vestures11311043vestures
vetches153411263vetches
viscus11428503viscu_s
welches153710313welches
wenches152914133wenches
yeses85119323yes__es
yesses93615813yes_ses

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272707.17318684.9
3Display Results2702700.0932903.2
 (SQL Overall)1786912707.67223291.3
 
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.