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

276 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
demes8603269(None) 
dames85435851dames
deems85421771deems
dees56356631de_es
dekes105224451dekes
deles65139251deles
deme76536281deme_
demies94825801demies
demos86022991demos
denes65639721denes
dexes135224511dexes
dimes85833041dimes
domes85735561domes
emes65434661_emes
femes105626221femes
hemes105031081hemes
memes94927701memes
semes75731581semes
acmes96020652acmes
adeems946332adeems
aedes64625142aedes
almes75126542almes
bees65453382be_es
bemas96424282bemas
benes75536232benes
bermes106023002bermes
beses75830722beses
cames97047312cames
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
comes97246992comes
cremes104517992cremes
cymes1210118922cymes
daces85030682daces
dales66439742dales
dame77140312dame_
damns84916922damns
damps105220412damps
dams77444372dam_s
dares66146702dares
dates65639152dates
dazes155024142dazes
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
deaves105319532deaves
debs76530242de_bs
debts86418372debts
debyes1238102debyes
decks124822192decks
decos85522122decos
dee47665822de_e_
deed65340902de_ed
deeds75423762deeds
deem75432892de_em
deemed104713062deemed
deep76031882de_ep
deeps84921772deeps
deer56739022de_er
deers64930522deers
deet57356582de_et
deets65330242deets
defames132812252defames
defer94619752defer
defers105116942defers
defies104624052defies
defis96717502defis
degames113312622degames
degas75119162degas
deices94119372deices
deils65722862deils
deke95228762deke_
deked115718532deked
dele56843082dele_
deled75326542deled
delfs94918672delfs
delimes10314192delimes
delis64928542delis
dells66630942dells
dels56745472de_ls
delts65731792delts
delves104917082delves
demast9517062demast
demean9510562demean
demeans1039712demeans
dement93825142dement
dements103016622dements
demesne1035572demesne
demic105119192demic
demise94618322demise
demises103719562demises
demit84832302demit
demits94918072demits
demo77427552dem_o
demob104913502demob
demobs11429482demobs
demoed103713442demoed
demon86520312demon
demons94917722demons
demoses103815822demoses
demotes104717672demotes
demur8311162demur
demurs939772demurs
demy105422852dem_y
dene56643412dene_
denies74729642denies
dens55945072de_ns
dense65923502dense
dents65031802dents
dere56845902dere_
dermas94116812dermas
dermis94717162dermis
derms85022892derms
desex13311982desex
desks105913072desks
deter65028042deter
deters74724682deters
detest74122842detest
deuces94015512deuces
devas96218882devas
devel94217122devel
devels104313902devels
devest104418702devest
devs86424032de_vs
dewed105020302dewed
dews86230602de_ws
dexies145018342dexies
deys85027472de_ys
dices86434242dices
dienes75719902dienes
dies55653522d_ies
dieses75218692dieses
dikes105831332dikes
dime76237642dime_
dimer85625602dimer
dimers94321092dimers
dims75435022dim_s
dines66449152dines
dismes95617672dismes
dites66339152dites
dives95832402dives
does56554472d_oes
doges75630162doges
doles67843752doles
dome77240732dome_
domed95423262domed
doms76239572dom_s
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
drees65628522drees
dries64733672dries
duces86327472duces
dudes75424372dudes
dues56045502d_ues
dukes105023472dukes
dumas85420432dumas
dumbs105915752dumbs
dumps105220102dumps
dunes65332172dunes
dupes86425932dupes
dures65635922dures
dyes85331892d_yes
dykes135215572dykes
dynes95917582dynes
edemas9310502edemas
edges75718722edges
ekes86726602_ekes
eme55837182_eme_
emeu66723432_emeu
emeus76913332_emeus
ems56435492_em_s
emus66821682_emus
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fames105735922fames
feces105625362feces
fees76450602fe_es
feme96130542feme_
femmes135410212femmes
fems96428702fem_s
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fumes105224702fumes
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 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.0931921408.6
2DLD Change Limit538002764.23612700.7
3Display Results2762760.0932967.7
 (SQL Overall)1786912764.42240409.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.