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 “refect” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

516 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
refect11431933(None) 
defect124816171defect
prefect141011071prefect
refects124012741refects
refelt94521421refelt
reflect123913711reflect
reject154116281reject
resect84424701resect
affect1448902affect
defeat103817162defeat
defects134511522defects
deflect13399972deflect
deject164512842deject
detect94217402detect
effect1437442effect
eject145016042_eject
elect74327032_elect
erect74129332_erect
infect113413442infect
perfect141010832perfect
praefect1544772praefect
prefects1598132prefects
prelect111013832prelect
react74634332re_act
rebec94416542rebec_
rebeck14419912rebeck
rebecs103913672rebecs
recent83630852recent
recept103319072recept
redact9419042redact
redefect1446052redefect
reeject16349622reeject
reelect911515632reelect
reerect92915882reerect
reest54938092re_est
reface113616352reface
refected142311662refected
refed93921922refe_d
refeed104717622refeed
refeel93913242refeel
refel84920812refe_l
refell94214442refell
refels94618052refels
refence12312232refence
refer84822142refe_r
refers93921082refers
refit84230062ref_it
reflects13288872reflects
reflet94024232reflet
refract121311602refract
reft75141272ref__t
regent74127672regent
reheat94423942reheat
reinfect1346482reinfect
rejects163910692rejects
relent64431852relent
relet54749822rele_t
relict83623902relict
reluct83916112reluct
remeet86325472remeet
remelt85123122remelt
remet74843722reme_t
renest64529712renest
repeat85127212repeat
repent84728872repent
rerent63832452rerent
reseat64131492reseat
resects94115592resects
resent63833622resent
reset55051862rese_t
respect11412032respect
retest64028452retest
revert93529112revert
revest94623602revest
revet84938842reve_t
rewet85135152rewe_t
rifest93114582rifest
select82621172select
abject17137703abject
advect12309123advect
affects1535393affects
artefact1345183artefact
aspect10612823aspect
bedeck1536213bedeck
beech124315503be_ech
beet66457543be_e_t
befell11428713befell
befit105222663bef_it
befleck1843943befleck
befret11315963befret
beget85632563bege_t
behest11314613behest
bereft114317303bereft
beret74946363bere_t
beset76739133bese_t
bewept13410323bewept
bisect10312873bisect
breech13348263bre_ech
brevet115717333breve_t
briefest1335893briefest
cement103321673cement
coeffect1843933coeffect
coerect11913353coerect
confect143614273confect
credent10313973credent
deafest112911513deafest
deceit93018213deceit
decent94023703decent
decoct11313783decoct
deduct10610793deduct
deet57356583de_e_t
deface123113863deface
defat95426693def_at
defeats113511233defeats
defecate1438793defecate
defected15289973defected
defector14277953defector
defence1339893defence
defend113910493defend
defer94619753defe_r
defers105116943defers
deffest14308803deffest
deficit1339673deficit
deflects14336733deflects
deft85540223def__t
deftest112611713deftest
defunct1345773defunct
dejecta17376363dejecta
dejects17389223dejects
delict94320333delict
dement93825153dement
depict113514793depict
desert72725493desert
detects104011093detects
detent73624483detent
detest74122843detest
devest104418703devest
direct93817333direct
edict84722283_edict
educt85017103_educt
effects1535283effects
eft66038823_ef__t
egest65222343_egest
ejecta15337393_ejecta
ejects15409953_ejects
elects83315003_elects
enact73525363_enact
epact94921533_epact
erects84116183_erects
eruct74022353_eruct
event85924443_event
evert84929513_evert
evict104417143_evict
exact143516933_exact
exec135313943_exec_
execs14539723_execs
exert124624143_exert
expect1758903expect
exsect1558503exsect
fact97142543__fact
feat76458223__feat
feck134923433__feck
feet75352213__feet
felt75146933__felt
fest74949443__fest
fet66471633__fe_t
fewest12311663fewest
feyest12311403feyest
forefeet14129393forefeet
forefelt14117363forefelt
freest95318283fre_est
geest64829623ge_est
genet66038683gene_t
gerent73223103gerent
greet65835323gre_e_t
greyest11348343greyest
heft106736293hef__t
hereat93527413hereat
infects12279713infects
infest93315433infest
inflect1249223inflect
inject153210233inject
insect83916583insect
jefe146516883jefe__
jefes155613673jefe_s
keet85347343ke_e_t
leech104913213le_ech
leet45957903le_e_t
left76340483lef__t
leftest10269463leftest
liefest1038443liefest
meet65350553me_e_t
merest84725113merest
neglect1047363neglect
newest9314213newest
object17135803object
obtect10129633obtect
perfecta15115203perfecta
perfecto15105743perfecto
perfects15107353perfects
praefects1642873praefects
praelect1247533praelect
preact103220393pre_act
precent113520263precent
precept133112513precept
predict12315323predict
preelect1249643preelect
preerect1259273preerect
preface14510923preface
prefer113813203prefe_r
prefers123713333prefers
preheat12413893preheat
prelects1299723prelects
premeet11615153premeet
present94022733present
preset84430983prese_t
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
project1838453project
prosect11313393prosect
protect11313633protect
raft76245913raf__t
ramet75743143rame_t
rarest65725483rarest
rawest93615063rawest
reach105123883re_ach
reacts83616603re_acts
reagent8716603reagent
realest73322433realest
rebait8320403rebait
rebecks15288013rebecks
rebel73421293rebe_l
rebels84518133rebels
reblent9614253reblent
reboot84119333reboot
rebut75927383re_but
rec55645463r__ec_
recant83228683recant
recast83422773recast
recce9514563re_cce
recces10614913recces
recede95515533recede
receipt1159253receipt
recency1438633recency
recepts113010263recepts
recess8314263recess
recheat12415933recheat
recheck1835613recheck
recit75235103re_cit
reck106130563r__eck
recoat84024273recoat
recock145112723recock
recs65734183r__ecs
recta74220263r__ecta
recti73619623r__ecti
recto74520803r__ecto
recut74729243re_cut
redacts10510943redacts
reddest9311953reddest
rede55037673rede__
redear73515173redear
reded74829123rede_d
redeem9311533redeem
redefeat1246313redefeat
redefects1543793redefects
redefy13388763redefy
redeny102712733redeny
redes65139133rede_s
redeye103811793redeye
redipt94116743redipt
redirect11147993redirect
redneck1445113redneck
redock134311543redock
redout71820253redout
reduce9713253reduce
ree37974073re_e__
reecho11318653re_echo
reechy14367823re_echy
reed55549623re_e_d
reedit7617223reedit
reeds65430903re_eds
reedy910020293re_edy
reef74938213re_e_f
reefed103816583reefed
reefer93314363reefer
reefers103312593reefers
reefiest112811483reefiest
reefs85121663re_efs
reefy114217703re_efy
reejects17336083reejects
reek85232523re_e_k
reeks94124033re_eks
reeky125416263re_eky
reel45240533re_e_l
reelects103110883reelects
reels55333263re_els
reemit8717223reemit
reenact9413013reenact
reerects10319923reerects
rees45364193re_e_s
reests64618893re_ests
reeve84121323re_eve
ref66053293ref___
refaced133713573refaced
refaces123216743refaces
refall94314393refall
refecting152413353refecting
refection141512283refection
refective1749113refective
refectory1746023refectory
refeeds11368973refeeds
refeels10379693refeels
refenced1438993refenced
refences13311843refences
referee101615753referee
referent112813423referent
reffed134712513reffed
refight1488873refight
refile95122373refile
refill94514053refill
refilm114311403refilm
refind104717073refind
refine95225693refine
refire95419473refire
refits94017653refits
refix155212483ref_ix
reflag1098083reflag
reflate103516263reflate
reflected1547983reflected
reflector1445733reflector
reflets103513153reflets
reflew12389453reflew
reflex16359513reflex
refloat10310833refloat
reflow12379653reflow
refluent1147433refluent
reflux16315413reflux
refly113914563ref_ly
refocus1236973refocus
refold103812113refold
reforest1139963reforest
reform11312713reform
refracts13137383refracts
refresh1335453refresh
refront10313263refront
refry114412463ref_ry
refs75732243ref__s
refuel93912623refuel
refuels10399523refuels
refuge105312613refuge
refund104810303refund
refuse94817513refuse
refute95515703refute
regear73512743regear
regency1337363regency
regents83416543regents
reges65628793rege_s
regilt71217493regilt
reglet73724233reglet
regreet83015953regreet
regret73723533regret
rehear93713223rehear
reheats104513523reheats
reheel93610823reheel
rehem103815353rehe_m
rehems113410983rehems
reinfects1444723reinfects
reinject1745543reinject
rejected182710113rejected
rejectee17289623rejectee
rejecter17258943rejecter
rejector17237723rejector
rekey124014733reke_y
rekeys13347693rekeys
reknit10312533reknit
reknot10311733reknot
relace83122153relace
relend76116453relend
relents74018503relents
relets64025673relets
releve95116403releve
relic74623363relic_
relics84517903relics
relicts94414593relicts
relist64628413relist
relit55340683re_lit
relock124713523relock
relucts9369673relucts
remedy1237873remedy
remeets93712413remeets
remelts93511493remelts
remend95216553remend
remex146315793reme_x
remint85329983remint
remit75737223re_mit
remixt155014853remixt
renege72713763renege
renests74014213renests
renew83917513rene_w
renews93811753renews
rennet64624853rennet
rent46661243r__ent
reobject1953113reobject
repack142412163repack
repast83520633repast
repeal84718283repeal
repeats94316053repeats
repeg84015053repe_g
repegs93311943repegs
repel74921403repe_l
repels84318763repels
repents93717623repents
reperk122511773reperk
replot83818593replot
report85326023report
repot75132623re_pot
request16311023request
rerack122513163rerack
reread71715433reread
rerents73319423rerents
resat55139683re_sat
reseal64819643reseal
reseats74319583reseats
reseau64216213reseau
resected112514743resected
reseda739703reseda
resee54336333rese_e
reseed74823293reseed
reseek103813133reseek
reseen64318413reseen
resees63827483resees
reselect1059943reselect
resell64215203resell
resend75016773resend
resents74221223resents
resets65427613resets
resew84519503rese_w
resewn9459813resewn
resews94814173resews
reshot93519633reshot
resift94017723resift
resist64524533resist
resit54241043re_sit
resmelt9411773resmelt
resort65728623resort
respects1247703respects
respelt9312143respelt
respot83117633respot
rest46459843r__est
result6318223result
ret35982833r__e_t
retack122612823retack
retch104818303re_tch
rete44944133rete__
reteach1237413reteach
reteam83214533reteam
retear63115483retear
retell63813643retell
retem74221953rete_m
retems83914573retems
retene69224273retene
retests73813853retests
retint65633443retint
retort66831153retort
retract91318113retract
retreat7317533retreat
reveal94115053reveal
revel84423163reve_l
revels94220573revels
reverb113912573reverb
revere94621253revere
revers94529633revers
reverts104715043reverts
revery124014213revery
revests104413733revests
revets94022173revets
revolt9316223revolt
rewear93012003rewear
rewed95425453rewe_d
reweds104412303reweds
reweld103711113reweld
rewets94617213rewets
rexes124526953rexe_s
rezero1578873rezero
rident7520193rident
rife74632323rife__
rifely123710033rifely
rifer84721983rife_r
rift75642333rif__t
ripest84317943ripest
rivet85636363rive_t
rodent7519243rodent
roset55945243rose_t
rudest74016313rudest
safest95016603safest
sect67443623__sect
selects91912143selects
seneca839793seneca
serest64831613serest
tenet55542213tene_t
tercet83624913tercet
traject1637043traject
trevet94818913treve_t
trifecta1343573trifecta
trisect939733trisect
unfelt92413463unfelt
webfeet1544593webfeet
weest85026773we_est
weet75254153we_e_t
weft105435013wef__t
xebec16378293xebec_
xebecs17355363xebecs
zebec18419263zebec_
zebeck23255203zebeck
zebecs19316183zebecs

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127165164.92322895.8
3Display Results5165160.1703035.3
 (SQL Overall)1786915165.46632691.4
 
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.