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

121 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
effs10511403(None) 
eff96128621eff_
efs66829601e_fs
efts76519481efts
offs107117011offs
teffs115111731teffs
aff95537612aff_
arfs76029962arfs
baffs134718052baffs
beefs105618562beefs
biffs134814412biffs
boffs134915502boffs
buffs135519512buffs
caffs135417372caffs
coffs134916302coffs
cuffs135017492cuffs
daffs125116422daffs
defis96717502defis
delfs94918672delfs
diffs126315482diffs
difs86027322difs
doffs125614332doffs
duffs125216622duffs
ears46356592ears
eats47054872eats
ebbs82411992ebbs
ecus65421462ecus
edhs86212102edhs
eds46638922e_ds
eels46536742eels
ef57345362e_f_
effuse1234962effuse
eft66038822e_ft
eggs66516152eggs
egis56520652egis
egos55821652egos
ekes86726602ekes
elds56324852elds
elf66138522elf_
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
emes65434662emes
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
es29048222e__s
eses45336102eses
ess36030882e_ss
etas46432272etas
eths76619522eths
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eyes75837882eyes
fas68262932_fas
feds85234312feds
fees76450602fees
fehs106522382fehs
fems96428702fems
fens76139762fens
feoffs1163702feoffs
fes66551672_fes
fess76529162fess
fets75345942fets
feus75830752feus
gaffs124914652gaffs
guffs124414822guffs
hefts116218152hefts
huffs144514742huffs
iff96730392iff_
iffy135312282iffy
ifs67124242_ifs
jefes155613672jefes
jiffs185710312jiffs
kafs116423742kafs
keefs125116282keefs
kefs115922742kefs
kerfs125413572kerfs
kifs116023502kifs
leafs85721182leafs
lefts86517812lefts
luffs114516282luffs
miffs134512882miffs
muffs134114212muffs
naffs116213962naffs
neifs85613042neifs
oafs76425262oafs
off96331632off_
pelfs105016292pelfs
pfft12311882pfft
puffs134114932puffs
raffs115017522raffs
reefs85121662reefs
refs75732242refs
reifs84819092reifs
riffs115114612riffs
rifs74929002rifs
ruffs114516742ruffs
seifs85019332seifs
selfs85220242selfs
serfs84922012serfs
teff106023762teff_
tiffs114414882tiffs
toffs116016722toffs
tuffs115118262tuffs
waffs146315472waffs
wefts116715492wefts
yaffs145311122yaffs

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 Filter178691298720.1101624463.6
2DLD Change Limit298721211.50019914.7
3Display Results1211210.0631920.6
 (SQL Overall)1786911211.673106808.7
 
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.