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

213 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
refed9392192(None) 
reded74829121reded
reed55549621re_ed
reefed103816581reefed
refeed104717621refeed
refel84920811refel
refer84822141refer
reffed134712511reffed
rewed95425451rewed
beefed123510872beefed
breed85526692bre_ed
brewed125411872brewed
briefed1335742briefed
ceded96118562ceded
cered85227442cered
chefed155010562chefed
creed85727392cre_ed
creped114115702creped
crewed125316562crewed
deed65340902de_ed
defend113910492defend
defer94619752defer
defied115016382defied
deked115718532deked
deled75326542deled
dewed105020302dewed
dreed75222842dre_ed
eked96718022_eked
erred65915672erred
exed125420592_exed
eyed86623232_eyed
fed76548352__fed
feed84538902fe_ed
feted94420932feted
feued94715662feued
fifed125115972fifed
freed95223542fre_ed
geed65435502ge_ed
greed75125692gre_ed
greyed114610602greyed
heed86437602he_ed
hefted134911422hefted
hewed125619432hewed
hexed165615762hexed
jeed125428502je_ed
jefe146516882jefe_
jefes155613672jefes
jewed165114832jewed
kerfed14358232kerfed
keyed1369392keyed
leafed105713872leafed
meed74934702me_ed
meted85424432meted
mewed115218012mewed
need54934152ne_ed
offed12359162offed
peed76239182pe_ed
preed85128122pre_ed
prefer113813202prefer
premed114617762premed
preyed125313202preyed
raced87635312raced
rafted104714702rafted
raged74829452raged
raked105831422raked
raped85334622raped
rared65738322rared
rased65033932rased
rated65441382rated
raved94931432raved
raxed135622662raxed
rayed95127502rayed
razed155027982razed
read55942532re_ad
readd74617132readd
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
rebec94416542rebec
rebel73421292rebel
rebid85121362rebid
rebred95816352rebred
recede95515532recede
recked134821802recked
red46755802r__ed
redd66323172re_dd
redded94019552redded
rede55037672rede_
redes65139132redes
redid74922392redid
redyed114611242redyed
ree37974072re_e_
reeded84022562reeded
reeds65430902re_eds
reedy910020292re_edy
reef74938212re_ef
reefer93314362reefer
reefs85121662reefs
reefy114217702reefy
reek85232522re_ek
reeked113717642reeked
reel45240532re_el
reeled74725532reeled
rees45364192re_es
reeved104118712reeved
ref66053292ref__
refaced133713572refaced
refect114319332refect
refeeds11368972refeeds
refeel93913242refeel
refell94214442refell
refels94618052refels
refelt94521422refelt
refers93921082refers
refiled114318652refiled
refind104717072refind
refined114720002refined
refired115116992refired
refit84230062refit
refix155212482refix
refixed183611152refixed
reflet94024232reflet
reflew12389452reflew
reflex16359512reflex
refly113914562refly
refold103812112refold
refried113513872refried
refry114412462refry
refs75732242ref_s
reft75141272ref_t
refuel93912622refuel
refuged125410872refuged
refund104810302refund
refused115114442refused
refuted114313802refuted
reges65628792reges
rehem103815352rehem
reified112913782reified
reined74425522reined
reived104518132reived
rekey124014732rekey
relend76116452relend
relet54749822relet
relied74926232relied
remedy1237872remedy
remend95216552remend
remet74843722remet
remex146315792remex
rend56136572re_nd
rended84524102rended
renew83917512renew
rented74426592rented
repeg84015052repeg
repel74921402repel
repled93319782repled
repped114616722repped
reread71715432reread
reseda739702reseda
resee54336332resee
reseed74823292reseed
resend75016772resend
reset55051862reset
resew84519502resew
resid64124092resid
resod64720052resod
rested74430782rested
rete44944132rete_
retem74221952retem
retied75924982retied
retted74826312retted
reused75419562reused
revel84423162revel
revet84938842revet
revved13469722revved
reweds104412302reweds
reweld103711112reweld
rewet85135152rewet
rexes124526952rexes
riced85825542riced
rife74632322rife_
rifer84721982rifer
riffed133811562riffed
rifled104115002rifled
rifted104115312rifted
riled65833252riled
rimed84826372rimed
riped85226432riped
rived94825612rived
robed85323732robed
rolfed104510522rolfed
roofed105214742roofed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
rued55729792r_ued
ruffed134312742ruffed
ruled65822522ruled
ryked13669512ryked
seed55549482se_ed
selfed10310912selfed
sered65737292sered
sewed95325162sewed
sexed136618542sexed
teed55439262te_ed
tewed94718532tewed
treed65626732tre_ed
unfed94614222unfed
vexed165713112vexed
webfed1535032webfed
weed85637512we_ed
wifed125117742wifed

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.313570897.8
2DLD Change Limit538002131.43637465.2
3Display Results2132130.0633381.0
 (SQL Overall)1786912131.81298615.3
 
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.