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

236 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
femes10562622(None) 
demes86032691demes
emes65434661_emes
fames105735921fames
feces105625361feces
fees76450601fe_es
feme96130541feme_
femmes135410211femmes
fems96428701fem_s
feres86038181feres
fetes85630141fetes
fezes175220021fezes
fumes105224701fumes
hemes105031081hemes
memes94927701memes
semes75731581semes
acmes96020652acmes
aedes64625142aedes
almes75126542almes
bees65453382be_es
bemas96424282bemas
benes75536232benes
bermes106023002bermes
beses75830722beses
cames97047312cames
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
comes97246992comes
cremes104517992cremes
cymes1210118922cymes
dames85435852dames
deems85421772deems
dees56356632de_es
dekes105224452dekes
deles65139252deles
deme76536282deme_
demies94825802demies
demos86022992demos
denes65639722denes
dexes135224512dexes
dimes85833042dimes
domes85735562domes
ekes86726602_ekes
eme55837182_eme_
emeu66723432_emeu
emeus76913332_emeus
ems56435492_em_s
emus66821682_emus
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
faces106439432faces
fades94932862fades
faeces114713122faeces
fakes126032482fakes
fame95639392fame_
famed115928342famed
fanes84639892fanes
fares85852872fares
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
fears84829392fears
fease84824872fease
feases95422922feases
feats86432752feats
feazes184514172feazes
fecks145417852fecks
fedex1699592fedex
feds85234312fe_ds
fee66862012fe_e_
feeb96924542fe_eb
feebs106112682feebs
feed84538902fe_ed
feeds94921142feeds
feel75233842fe_el
feels85223042feels
feet75352212fe_et
feezes184412612feezes
fehs106522382fe_hs
fells85327382fells
felts85324542felts
fem86040732fem__
females12310662females
femme125011432femme
femur1038682femur
femurs1136712femurs
fences114617112fences
fends96324972fends
fens76139762fe_ns
feods99516852feods
fere76342232fere_
fermis114313502fermis
ferns85220082ferns
fes66551672f__es
fess76529162fe_ss
fesse86116332fesse
fesses94820252fesses
fests85828042fests
fetas85624402fetas
fete75734922fete_
feted94420932feted
fets75345942fe_ts
fetus85816542fetus
feuds95914882feuds
feued94715662feued
feus75830752fe_us
fever115617952fever
fevers125414892fevers
fewer115216122fewer
fewest12311662fewest
feyer115014522feyer
feyest12311402feyest
fezzes174910402fezzes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
flames114723692flames
flees85828752flees
flexes164512952flexes
flies85630712flies
floes85528142floes
flues84626922flues
flumes115119732flumes
foemen11310522foemen
foes76543442f_oes
fores85847102fores
formes114623712formes
foxes156321092foxes
frames115119862frames
frees86131392frees
freres94716172freres
fries85535602fries
froes86126692froes
fume96727632fume_
fumed116118822fumed
fumer105918232fumer
fumers113613382fumers
fumet105630222fumet
fumets114311812fumets
fuses85628422fuses
fuzes175120222fuzes
fyces139813642fyces
fykes156312692fykes
games86238552games
gees55647882ge_es
gems75329112gem_s
genes65133092genes
hames106138702hames
hebes105521672hebes
heme95034412heme_
hemps126917332hemps
hems95534942hem_s
heres86245902heres
hexes155123042hexes
homes106938812homes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
kames115024692kames
kemps135012522kemps
kermes124616122kermes
kexes166216812kexes
lames75445542lames
lees45455882le_es
leges64427282leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
limes75636502limes
meme85330552meme_
memos95719112memos
mems85931502mem_s
meres75143572meres
metes74736212metes
mezes167719262mezes
mimes95732022mimes
momes95134472momes
names74833362names
neems77316292neems
nemas75321572nemas
nenes55329672nenes
neumes83112622neumes
neves87021872neves
nomes74933122nomes
pedes85327282pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pomes94833932pomes
redes65139122redes
rees45364192re_es
reges65628782reges
remet74843722remet
remex146315792remex
rems66237722rem_s
rexes124526952rexes
rhemes115913182rhemes
rimes75634542rimes
seems75525022seems
sees45361052se_es
seme65836652seme_
semen75724102semen
semens84616962semens
semis74623532semis
seres55448892seres
sexes126126222sexes
tames75242012tames
teems76019782teems
tees45353582te_es
teles54536002teles
temps95417132temps
themes115319252themes
times75630822times
tomes76037382tomes
vees75439432ve_es
veges94118862veges
vermes115019142vermes
vexes155719122vexes
wames106432802wames
wees76249122we_es
yeses85119322yeses
zees136331892ze_es
zymes1924712942zymes

Search took 2 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.0931921408.6
2DLD Change Limit538002361.70331591.3
3Display Results2362360.0633746.0
 (SQL Overall)1786912361.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.