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

127 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
jefe14651688(None) 
jee106648641je_e
jefes155613671jefes
jete115927251jete
ajee115928232aje_e
bee56262402be_e
beef96233672beef
bene66439492bene
cafe95230322cafe
cede74928762cede
cee55952702ce_e
cepe84926652cepe
cere66741472cere
cete64934782cete
dee47665822de_e
def76546722def_
defer94619752defer
defi86321492defi
deft85540222deft
defy114921262defy
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
dere56845902dere
ef57345362_ef_
eff96128622_eff
efs66829602_efs
eft66038822_eft
eke75630092_eke
eme55837182_eme
ere36352772_ere
eve66331162_eve
ewe66630982_ewe
eye65539772_eye
fe57944742__fe
fee66862012fe_e
feme96130542feme
fere76342232fere
fete75734922fete
fife106027702fife
gee45359202ge_e
gene56237222gene
hebe96424702hebe
heft106736292heft
heme95034412heme
here76447102here
jade125325442jade
jake155925772jake
jane115031472jane
jape134923422jape
jean116629282jean
jebel145612142jebel
jeed125428502jeed
jeep135624842jeep
jeer115426462jeer
jees115938542jees
jeez205622032jeez
jehu145614862jehu
jell117125872jell
jeon116821442jeon
jerk154920132jerk
jess116022032jess
jesse126012832jesse
jest116738502jest
jet106754822je_t
jetes124922842jetes
jets115834102jets
jeu105532072je_u
jeux184311272jeux
jew135129082je_w
jewed165114832jewed
jewel156711702jewel
jews145822082jews
jibe136323382jibe
jiff175321402jiff
jive146123592jive
joe106642352j_oe
joke155926162joke
jole117233822jole
jube136322782jube
juke154721662juke
jupe134921002jupe
jute115327892jute
keef115829992keef
kef105639662kef_
kefs115922742kefs
lee36068142le_e
left76340482left
leke85527402leke
life75433732life
meme85330552meme
mere67244442mere
mete64438132mete
meze154420902meze
nee36657782ne_e
nene45932062nene
neve76224832neve
pee56066512pe_e
peke105926202peke
pele65539552pele
pere66450262pere
rede55037662rede
ree37974072re_e
reef74938212reef
ref66053292ref_
refed93921922refed
refel84920812refel
refer84822142refer
refs75732242refs
reft75141272reft
rete44944132rete
rife74632322rife
safe75930952safe
see35772262se_e
seme65836652seme
sene46848052sene
sere46153472sere
tee38366872te_e
teff106023762teff
tele45040872tele
vee65750182ve_e
wee66760812we_e
weft105435012weft
were76238332were
wife105228022wife
zee126143232ze_e

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 Filter178691298720.0762351197.4
2DLD Change Limit298721271.00029872.0
3Display Results1271270.0333848.5
 (SQL Overall)1786911271.109161128.0
 
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.