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

136 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
jefes15561367(None) 
jees115938541je_es
jefe146516881jefe_
jetes124922841jetes
aedes64625152aedes
beefs105618562beefs
bees65453382be_es
benes75536232benes
beses75830722beses
cafes106426922cafes
cedes84927332cedes
cees65941592ce_es
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
dees56356632de_es
defer94619752defer
defers105116942defers
defies104624052defies
defis96717502defis
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
effs105114032_effs
efs66829602_ef_s
efts76519482_efts
ekes86726602_ekes
emes65434662_emes
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fes66551672__fes
fetes85630142fetes
fezes175220022fezes
fifes114822392fifes
gees55647882ge_es
genes65133092genes
hebes105521672hebes
hefts116218152hefts
hemes105031082hemes
heres86245902heres
hexes155123042hexes
jades135222112jades
jakes165023642jakes
janes124928122janes
japes146322822japes
jeans126022112jeans
jebel145612142jebel
jebels15418912jebels
jee106648642je_e_
jeed125428502je_ed
jeep135624842je_ep
jeeps144715372jeeps
jeer115426462je_er
jeers124818132jeers
jeez205622032je_ez
jehus15488572jehus
jells125522162jells
jerks166514892jerks
jess116022032je_ss
jesse126012832jesse
jesses135215952jesses
jests125922452jests
jete115927252jete_
jets115834102je_ts
jewed165114832jewed
jewel156711702jewel
jewels16508612jewels
jews145822082je_ws
jibes145520322jibes
jiffs185710312jiffs
jives154820812jives
joes116635892j_oes
jokes165423332jokes
joles125230832joles
jones125028182jones
jubes145420742jubes
jukes165319102jukes
jupes145218552jupes
jutes125125132jutes
keefs125116282keefs
kefs115922742kef_s
kexes166216822kexes
lees45455882le_es
lefts86517812lefts
leges64427292leges
lenes54738522lenes
leses54930812leses
lexes127225262lexes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
nenes55329672nenes
neves87021872neves
pedes85327292pedes
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
redes65139132redes
reefs85121662reefs
rees45364192re_es
refed93921922refed
refel84920812refel
refels94618052refels
refer84822142refer
refers93921082refers
refs75732242ref_s
reges65628792reges
rexes124526952rexes
safes85226722safes
sees45361052se_es
semes75731582semes
seres55448892seres
sexes126126222sexes
tees45353582te_es
teffs115111732teffs
teles54536002teles
vees75439432ve_es
veges94118872veges
vexes155719122vexes
wees76249122we_es
wefts116715492wefts
wifes114522562wifes
yeses85119322yeses
zees136331892ze_es

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.330541487.9
2DLD Change Limit538001361.36039558.8
3Display Results1361360.0304533.3
 (SQL Overall)1786911361.720103890.1
 
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.