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

432 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
refell9421444(None) 
befell11428711befell
refall94314391refall
refeel93913241refeel
refel84920811refe_l
refels94618051refels
refelt94521421refelt
refill94514051refill
resell64215201resell
retell63813641retell
bedell93610042bedell
befall114410642befall
fell76833072__fell
presell939302presell
pretell938242pretell
rebel73421292rebe_l
rebels84518132rebels
rebill84713252rebill
recall83815722recall
reel45240532re_e_l
reels55333262re_els
refalls103312242refalls
refect114319332refect
refed93921922refe_d
refeed104717622refeed
refeels10379692refeels
refelled122810172refelled
refer84822142refe_r
refers93921082refers
refile95122372refile
refills103711422refills
refilm114311402refilm
reflet94024232reflet
reflew12389452reflew
reflex16359512reflex
refly113914562ref_ly
refold103812112refold
refuel93912622refuel
refuels10399522refuels
reheel93610822reheel
remelt85123122remelt
repeal84718282repeal
repel74921402repe_l
repels84318762repels
repoll8410792repoll
reroll6412682reroll
reseal64819642reseal
resells73313202resells
respell947022respell
retells73211522retells
reveal94115052reveal
revel84423162reve_l
revels94220572revels
reweld103711112reweld
rifely123710032rifely
bedel84219403bede_l
bedells10379363bedells
bedels94015273bedels
befalls12349123befalls
beflea1147123beflea
befool1137713befool
befoul1137253befoul
begall92610723begall
beheld1236413beheld
bell66237183__bell
betel74419903bete_l
betels84515063betels
bevel104517043beve_l
bevels113913983bevels
bezel165215173beze_l
bezels173712283bezels
cell65031723__cell
cereal8315833cereal
creel75121483cre_e_l
creels84416943cre_els
crenel84213063crene_l
crenelle1046333crenelle
crenels93711013crenels
crewel114310483crewe_l
crewels12438493crewels
defeat103817163defeat
defect124816173defect
defend113910493defend
defer94619753defe_r
defers105116943defers
defile105216663defile
deflea1037443deflea
deftly1336533deftly
defuel10348933defuel
defuels11296983defuels
dell56938203__dell
devel94217123deve_l
devels104313903devels
dewfall1453763dewfall
drywell1442373drywell
dwell9519853_dwell
eel37946843_e_e_l
eels46536743_e_els
eely77725213_e_ely
ell36735683___ell
fall75535313__fall
farewell1443313farewell
feal713940423__feal
feel75233843__feel
feels85223043fe_els
fella84918653__fella
fells85327383__fells
felly114922803__felly
felt75146933__felt
fill75540193__fill
forefeel14105513forefeel
forefelt14117363forefelt
foretell1146123foretell
freely12310963fre_ely
full75229153__full
harebell1344353harebell
heel75034223he_e_l
heels85625533he_els
hell75637893__hell
icefall1254303icefall
infall939403infall
infill938413infill
ireful948713iref_ul
irefully1445943irefully
jebel145612143jebe_l
jebels15418913jebels
jefe146516883jefe__
jefes155613673jefe_s
jell117125873__jell
jewel156711703jewe_l
jewels16508613jewels
keel85729473ke_e_l
keels94622413ke_els
kevel124213103keve_l
kevels134410713kevels
knell94210923_knell
kvell12436693_kvell
level84116553leve_l
levelly1335853levelly
levels94113283levels
mell64935613__mell
merely111312593merely
micell1098193micell
newel86114133newe_l
newels93710823newels
peel65535613pe_e_l
peels75226423pe_els
prebill1138803prebill
predella1145393predella
prefect141011073prefect
prefer113813203prefe_r
prefers123713333prefers
prefile123413183prefile
premeal11310523premeal
prepill1147583prepill
presells1058283presells
pretells1047333pretells
quell144311433_quell
raffle123910703raffle
rakehell1542333rakehell
rarely93513653rarely
ratel54224883rate_l
ratels64518213ratels
ravel84621513rave_l
ravelly13268353ravelly
ravels94717073ravels
real45750293r__eal
realer63528593realer
reales64934123reales
really93315613really
realm75621623re_alm
reals55038653re_als
rebec94416543rebe_c
rebeck14419913rebeck
rebecs103913673rebecs
rebelled113110333rebelled
rebills93510623rebills
reboil83814683reboil
recalls92613623recalls
recede95515533recede
recent83630853recent
recept103319073recept
recess8314263recess
recoal84117973recoal
recoil84016723recoil
rectal84418133rectal
reddle83815913reddle
rede55037673rede__
redear73515173redear
reded74829123rede_d
redeem9311533redeem
redefy13388763redefy
redeny102712733redeny
redes65139133rede_s
redeye103811793redeye
redial74923113redial
redleg839273redleg
redly94217203re_dly
redpoll1045043redpoll
redrill857893redrill
ree37974073re_e__
reed55549623re_e_d
reeds65430903re_eds
reedy910020293re_edy
reef74938213re_e_f
reefed103816583reefed
reefer93314363reefer
reefers103312593reefers
reefs85121663re_efs
reefy114217703re_efy
reek85232523re_e_k
reeks94124033re_eks
reeky125416263re_eky
reeled74725533re_eled
reeler63822573re_eler
rees45364193re_e_s
reest54938093re_est
reeve84121323re_eve
ref66053293ref___
reface113616353reface
refallen1136213refallen
refects124012743refects
refeeds11368973refeeds
refelling132211313refelling
refence12312233refence
referee101615753referee
referral1144403referral
reffed134712513reffed
refiled114318653refiled
refiles104122423refiles
refilled12278673refilled
refilms12347503refilms
refind104717073refind
refine95225693refine
refire95419473refire
refit84230063ref_it
refits94017653refits
refix155212483ref_ix
reflag1098083reflag
reflect123913713reflect
reflets103513153reflets
reflexly2142463reflexly
reflow12379653reflow
reflux16315413reflux
refolds11298953refolds
reform11312713reform
refresh1335453refresh
refry114412463ref_ry
refs75732243ref__s
reft75141273ref__t
refueled1286573refueled
refuelled1364513refuelled
refuge105312613refuge
refund104810303refund
refusal1056893refusal
refuse94817513refuse
refutal1046943refutal
refute95515703refute
regal65023793re_gal
regale74821453regale
regally1159873regally
regear73512743regear
regent74127673regent
reges65628793rege_s
regild8149773regild
regilt71217493regilt
reglet73724233reglet
regnal74812933regnal
reguli738143reguli
rehear93713223rehear
reheat94423943reheat
reheels10298253reheels
rehem103815353rehe_m
rehems113410983rehems
reject154116283reject
rekey124014733reke_y
rekeys13347693rekeys
relend76116453relend
relent64431853relent
relet54749823rele_t
relets64025673relets
releve95116403releve
rely75428953r__ely
remail85017123remail
remedy1237873remedy
remeet86325473remeet
remelts93511493remelts
remend95216553remend
remet74843723reme_t
remex146315793reme_x
remold93412973remold
renail65020763renail
renal55929503re_nal
renege72713763renege
renest64529713renest
renew83917513rene_w
renewal1038703renewal
renews93811753renews
rental63922023rental
reoil55321183re_oil
reoils64516873reoils
repeals94014523repeals
repeat85127213repeat
repeg84015053repe_g
repegs93311943repegs
repelled113111593repelled
repeller103010403repeller
repent84728873repent
reperk122511773reperk
repled93319783repled
reply104015853re_ply
repolls939053repolls
reread71715433reread
rerent63832453rerent
rerolls739943rerolls
resail64418733resail
resale64025543resale
reseals73917673reseals
reseat64131493reseat
reseau64216213reseau
resect84424703resect
reseda739703reseda
resee54336333rese_e
reseed74823293reseed
reseek103813133reseek
reseen64318413reseen
resees63827483resees
reseller83412253reseller
resend75016773resend
resent63833623resent
reset55051863rese_t
resets65427613resets
resew84519503rese_w
resewn9459813resewn
resews94814173resews
resile64627673resile
resmelt9411773resmelt
resold73915363resold
resole64624183resole
respells1056333respells
respelt9312143respelt
result6318223result
retail65522073retail
retally10413683retally
rete44944133rete__
reteam83214533reteam
retear63115483retear
retem74221953rete_m
retems83914573retems
retene69224273retene
retest64028453retest
retial64724993retial
retile65929673retile
retold73013753retold
retool63914483retool
retral64419743retral
reveals103812723reveals
reveille1145333reveille
reveled113917753reveled
reveler104116343reveler
revelled123712743revelled
reveller112912193reveller
revelry1335693revelry
reverb113912573reverb
revere94621253revere
revers94529633revers
revert93529113revert
revery124014213revery
revest94623603revest
revet84938843reve_t
revets94022173revets
revile94921613revile
revolt9316223revolt
rewear93012003rewear
rewed95425453rewe_d
reweds104412303reweds
rewelds11457413rewelds
rewet85135153rewe_t
rewets94617213rewets
rexes124526953rexe_s
rezero1578873rezero
riel46432383r_ie_l
riels55121333r_iels
rife74632323rife__
rifer84721983rife_r
rifest93114583rifest
riffle124210233riffle
rifle85518333rif_le
rifled104115003rifled
rifler94014263rifler
rifles94217703rifles
rill45140903r__ill
ripely112511153ripely
roll46331653r__oll
roselle7310243roselle
rowel84721413rowe_l
rowels94515453rowels
rubel75416833rube_l
rubella9146523rubella
rubels84112993rubels
rudely10389973rudely
rueful948203ruef_ul
ruefully1445223ruefully
ruffle124111673ruffle
ruffly15336673ruffly
safely12249393safely
seel45042983se_e_l
seels55632823se_els
seely84522633se_ely
sell45840613__sell
shell84424123_shell
skell94915833_skell
smell74916233_smell
snell54517303_snell
spell75020303_spell
swell84815983_swell
teel46335803te_e_l
teels55726373te_els
tell44934703__tell
tramell9398703tramell
trefoil1066063trefoil
unfelt92413463unfelt
unsell63512543unsell
unwell9349443unwell
upwell11285803upwell
wedel94513963wede_l
wedeln10326693wedeln
wedels103811033wedels
weel75834083we_e_l
well75832043__well
wifely15429423wifely
yell76028323__yell

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.406440125.6
2DLD Change Limit1127164325.07622205.7
3Display Results4324320.1433021.0
 (SQL Overall)1786914325.62531767.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.