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 “feces” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

233 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
feces10562536(None) 
faces106439431faces
faeces114713121faeces
fecks145417851fecks
fees76450601fe_es
femes105626221femes
fences114617111fences
feres86038181feres
fetes85630141fetes
fezes175220021fezes
fices106031161fices
fyces139813641fyces
aces67645092_aces
aedes64625152aedes
becks135522012becks
bees65453382be_es
benes75536232benes
beses75830722beses
bices95029962bices
cedes84927332cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
daces85030682daces
decks124822192decks
decos85522122decos
dees56356632de_es
deices94119372deices
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
deuces94015512deuces
dexes135224512dexes
dices86434242dices
duces86327472duces
eches106322162_eches
ecus65421462_ecus
ekes86726602_ekes
emes65434662_emes
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
face96140122face_
faced117727652faced
facer105525052facer
facers115519442facers
facet106038522facet
facets116316652facets
facies113921592facies
facts107021892facts
fades94932862fades
fakes126032482fakes
falces115216002falces
fames105735922fames
fanes84639892fanes
farces115223322farces
fares85852872fares
fasces114914542fasces
fates85139232fates
fauces114916152fauces
faves115331422faves
faxes155726652faxes
fazes175527212fazes
fears84829392fears
fease84824872fease
feases95422922feases
feats86432752feats
feazes184514172feazes
fecal105119212fecal
feck134923432fec_k
fedex1699602fedex
feds85234322fe_ds
fee66862012fe_e_
feeb96924542fe_eb
feebs106112682feebs
feed84538902fe_ed
feeds94921142feeds
feel75233842fe_el
feels85223042feels
feet75352212fe_et
feezes184412612feezes
fehs106522382fe_hs
fells85327382fells
felts85324542felts
feme96130542feme_
femmes135410212femmes
fems96428702fe_ms
fence105319912fence_
fenced124412712fenced
fencer114613532fencer
fencers123810622fencers
fends96324972fends
fens76139762fe_ns
feods99516852feods
fere76342232fere_
ferns85220082ferns
fes66551672f__es
fescues1236782fescues
fess76529162fe_ss
fesse86116332fesse
fesses94820252fesses
fests85828042fests
fetas85624402fetas
fetches153413892fetches
fete75734922fete_
feted94420932feted
fets75345942fe_ts
fetus85816542fetus
feuds95914882feuds
feued94715662feued
feus75830752fe_us
fever115617952fever
fevers125414892fevers
fewer115216122fewer
fewest12311662fewest
feyer115014522feyer
feyest12311402feyest
fezzes174910402fezzes
fice95737122fice_
fiches145219532fiches
ficoes114613462ficoes
ficus105015492ficus
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
fleches153411442fleches
flecks154310802flecks
fleeces12399642fleeces
flees85828752flees
flexes164512952flexes
flies85630712flies
floes85528142floes
flues84626922flues
focus105815882focus
foes76543442f_oes
forces114422132forces
fores85847102fores
foxes156321092foxes
frees86131392frees
freres94716172freres
fries85535602fries
froes86126692froes
fucks144419252fucks
fucus105515892fucus
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fyce126316832fyce_
fykes156312692fykes
gecks125117092gecks
gees55647882ge_es
genes65133092genes
hebes105521672hebes
hecks145220652hecks
hemes105031082hemes
heres86245902heres
hexes155123042hexes
ices66129642_ices
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
kecks105416572kecks
kexes166216822kexes
laces76141762laces
leches115421312leches
lees45455882le_es
leges64427292leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
luces75528432luces
maces97139962maces
memes94927702memes
merces105720742merces
meres75143572meres
metes74736212metes
mezes167719262mezes
necks115119332necks
nenes55329672nenes
neves87021872neves
nieces84112712nieces
paces96741112paces
peaces106324082peaces
pechs125516202pechs
pecks135724432pecks
pecs84634102pec_s
pedes85327292pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pieces104217272pieces
puces94924632puces
races74943242races
recces10614912recces
recess8314262recess
recks115625132recks
recs65734182rec_s
redes65139132redes
rees45364192re_es
reges65628792reges
rexes124526952rexes
rices75536152rices
secs65033892sec_s
sects75622892sects
sees45361052se_es
semes75731582semes
seres55448892seres
sexes126126222sexes
sices75637272sices
syces106416462syces
taces76237802taces
techs106915832techs
tees45353582te_es
teles54536002teles
terces83921412terces
vees75439432ve_es
veges94118872veges
vexes155719122vexes
vices105725532vices
voces105918052voces
wees76249122we_es
yechs136112582yechs
yeses85119322yeses
zees136331892ze_es

Search took 5 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 Filter178691538000.593301333.9
2DLD Change Limit538002333.59314973.6
3Display Results2332330.0633698.4
 (SQL Overall)1786912334.24942054.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.