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

250 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
dekes10522445(None) 
dees56356631de_es
deke95228761deke_
deked115718531deked
deles65139251deles
demes86032691demes
denes65639721denes
dexes135224511dexes
dikes105831331dikes
dukes105023471dukes
dykes135215571dykes
ekes86726601_ekes
pekes114623561pekes
aedes64625142aedes
akees96119242akees
bakes117035372bakes
bees65453382be_es
benes75536232benes
beses75830722beses
bikes117529472bikes
cakes116037672cakes
cedes84927322cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
cokes115537192cokes
cukes115422092cukes
daces85030682daces
daks97130602dak_s
dales66439742dales
dames85435852dames
dares66146702dares
dates65639152dates
dazes155024142dazes
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
deaves105319532deaves
debs76530242de_bs
debts86418372debts
debyes1238102debyes
decked145217622decked
deckel134911042deckel
deckels14367362deckels
decker135215992decker
deckers144413832deckers
deckles143312802deckles
decks124822192decks
decos85522122decos
dee47665822de_e_
deed65340902de_ed
deeds75423762deeds
deem75432892de_em
deems85421772deems
deep76031882de_ep
deeps84921772deeps
deer56739022de_er
deers64930522deers
deet57356582de_et
deets65330242deets
defer94619752defer
defers105116942defers
defies104624052defies
defis96717502defis
degas75119162degas
deices94119372deices
deils65722862deils
dekares122710872dekares
dekko936392dekko
dekkos1034102dekkos
dele56843082dele_
deled75326542deled
delfs94918672delfs
delis64928542delis
dells66630942dells
dels56745472de_ls
delts65731792delts
delves104917082delves
deme76536282deme_
demies94825802demies
demos86022992demos
dene56643412dene_
denies74729642denies
dens55945072de_ns
dense65923502dense
dents65031802dents
dere56845902dere_
derms85022892derms
desex13311982desex
desks105913072desks
deter65028042deter
deters74724682deters
detest74122842detest
deuces94015512deuces
devas96218882devas
devel94217122devel
devels104313902devels
devest104418702devest
devs86424032de_vs
dewed105020302dewed
dews86230602de_ws
dexies145018342dexies
deys85027472de_ys
dices86434242dices
dienes75719902dienes
dies55653522d_ies
dieses75218692dieses
dike95935762dike_
diked115024682diked
diker105524552diker
dikers114418792dikers
dikey135116422dikey
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
does56554472d_oes
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
drakes114715862drakes
drees65628522drees
dreks105714742drek_s
dries64733672dries
duces86327472duces
dudes75424372dudes
dues56045502d_ues
duke95628102duke_
duked115218462duked
dunes65332172dunes
dupes86425932dupes
dures65635922dures
dyes85331892d_yes
dyke126418182dyke_
dyked145310952dyked
dykey16608672dykey
dynes95917582dynes
edges75718722edges
eke75630092_eke_
eked96718022_eked
emes65434662_emes
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fakes126032482fakes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
fykes156312692fykes
geeks104915842geeks
gees55647882ge_es
genes65133092genes
hakes126034302hakes
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hexes155123042hexes
hikes125426982hikes
hokes126231642hokes
jakes165023642jakes
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
jokes165423332jokes
jukes165319102jukes
keeks84717252keeks
kexes166216812kexes
kikes85122552kikes
lakes95737652lakes
leeks95318892leeks
lees45455882le_es
leges64427282leges
leke85527402leke_
leks85427602lek_s
lenes54738522lenes
leses54930812leses
lexes127225262lexes
likes96231902likes
makes115336852makes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mikes115129892mikes
mokes114631032mokes
nenes55329672nenes
neves87021872neves
nukes95418122nukes
okes84936342_okes
pedes85327282pedes
peeks115021112peeks
pees65257372pe_es
peke105926202peke_
pekoes124410422pekoes
peles75738082peles
penes75839222penes
peres76246642peres
pikes115031032pikes
pokes116133012pokes
pukes114523022pukes
rakes94440352rakes
redes65139122redes
reeks94124032reeks
rees45364192re_es
reges65628782reges
rekey124014732rekey
rekeys13347692rekeys
rexes124526952rexes
rykes125513032rykes
sakes95540752sakes
seeks94724642seeks
sees45361052se_es
semes75731582semes
seres55448892seres
sexes126126222sexes
sikes96236082sikes
skees95023122skees
sokes95031422sokes
sykes124816862sykes
takes94437792takes
tees45353582te_es
teles54536002teles
tikes95628902tikes
tokes95234972tokes
tykes125817062tykes
ukes86122812_ukes
vees75439432ve_es
veges94118862veges
vexes155719122vexes
wakes126633652wakes
weeks125017862weeks
wees76249122we_es
wekas123911792wekas
yeses85119322yeses
yikes125117752yikes
yokes125223022yokes
zees136331892ze_es
zeks175815062zek_s

Search took 3 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.1101624463.6
2DLD Change Limit538002501.95327547.4
3Display Results2502500.1232032.5
 (SQL Overall)1786912502.18681743.4
 
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.