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

286 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
reels5533326(None) 
creels84416941creels
eels46536741_eels
feels85223041feels
heels85625531heels
keels94622411keels
peels75226421peels
reals55038651reals
rebels84518131rebels
reeds65430901reeds
reefs85121661reefs
reeks94124031reeks
reel45240531reel_
rees45364191ree_s
refels94618051refels
repels84318761repels
revels94220571revels
riels55121331riels
seels55632821seels
teels55726371teels
ariels65119372ariels
artels66216232artels
axels126313632axels
bedels94015272bedels
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382bee_s
beets76131442beets
bells76432162bells
bels66142492_bels
betels84515062betels
bevels113913982bevels
bezels173712282bezels
breeds94914882breeds
breeks125310792breeks
brees75632552bree_s
cees65941592cee_s
ceils75019402ceils
cells75428062cells
cels65534972_cels
creeds94714772creeds
creeks124812922creeks
creel75121482creel_
creeps104213622creeps
crenels93711012crenels
crewels12438482crewels
deals65435342deals
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632dee_s
deets65330242deets
deils65722862deils
deles65139252deles
dells66630942dells
dels56745472_dels
devels104313902devels
drees65628522dree_s
duels65619232duels
eel37946842_eel_
eely77725212_eely
ells46431352_ells
els37645722__els
feebs106112682feebs
feeds94921142feeds
feel75233842feel_
fees76450602fee_s
fells85327382fells
freely12310952freely
freers94717302freers
frees86131392free_s
fuels87117352fuels
geeks104915842geeks
gees55647882gee_s
gels56836102_gels
greeds84314282greeds
greens75716872greens
grees65132472gree_s
greets75117422greets
gruels73910152gruels
heals85733452heals
heeds95420422heeds
heel75034222heel_
heils85222192heils
hells85032042hells
herls85226432herls
jebels15418912jebels
jeeps144715372jeeps
jeers124818132jeers
jees115938542jee_s
jells125522162jells
jewels16508612jewels
keefs125116282keefs
keeks84717252keeks
keel85729462keel_
keens95721182keens
keeps116020282keeps
keets95123482keets
kevels134410712kevels
kneels10408932kneels
koels94613902koels
kreeps12427412kreeps
leeks95318892leeks
leers54828982leers
lees45455882lee_s
leets54927122leets
levels94113282levels
meals75933372meals
meeds84920272meeds
meets74224612meets
mells75031332mells
mels65941532_mels
merls77423902merls
mewls105813232mewls
needs65719632needs
neems77316292neems
neeps75617882neeps
newels93710822newels
noels56418702noels
oriels64914622oriels
peals75235492peals
peeks115021112peeks
peel65535612peel_
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pee_s
peles75738082peles
preens85020112preens
prees75937172pree_s
rails55937402rails
rales54947492rales
ratels64518212ratels
ravels94717072ravels
reads64835272reads
real45750292real_
reales64934122reales
realm75621622realm
realms84913492realms
reams75729622reams
reaps75626192reaps
rears54739652rears
rebecs103913672rebecs
rebel73421292rebel_
rebs65733562r_ebs
rebus75721112rebus
recess8314262recess
recks115625132recks
recs65734182r_ecs
redds74617832redds
redes65139122redes
redly94217192redly
redos65126762redos
reds56042862r_eds
ree37974072ree__
reed55549622ree_d
reedy910020282reedy
reef74938212ree_f
reefy114217702reefy
reek85232522ree_k
reeky125416262reeky
reeled74725532reeled
reeler63822572reeler
reelers73520272reelers
reest54938092reest
reests64618892reests
reeve84121322reeve
reeves94721492reeves
refeels10379692refeels
refel84920812refel_
refell94214442refell
refelt94521422refelt
refers93921082refers
refly113914562refly
refs75732242r_efs
refuels10399522refuels
reges65628782reges
regs55436572r_egs
reheels10298252reheels
rehems113410982rehems
reifs84819092reifs
reins56234562reins
reis45343232r_eis
rekeys13347692rekeys
relet54749822relet
relets64025672relets
rely75428952r_ely
remelt85123122remelt
remelts93511492remelts
rems66237722r_ems
rends65129952rends
renews93811752renews
rents55935182rents
reoils64516872reoils
repeals94014522repeals
repegs93311942repegs
repel74921402repel_
reply104015852reply
repos74725792repos
repps95114342repps
reps65937952r_eps
res35565042r_e_s
reseals73917662reseals
resees63827482resees
resell64215202resell
resells73313202resells
resets65427612resets
resews94814172resews
rests54935872rests
retell63813642retell
retells73211522retells
retems83914572retems
rets45352562r_ets
reveals103812722reveals
revel84423162revel_
revers94529632revers
revets94022172revets
revs75027052r_evs
reweds104412302reweds
reweld103711112reweld
rewelds11457412rewelds
rewets94617212rewets
rexes124526952rexes
rheas84816952rheas
rials55026672rials
riel46432382riel_
riles55343642riles
rills55032712rills
roes45954132roe_s
roils54826792roils
roles56747982roles
rolls55326232rolls
rotls55620162rotls
rowels94515452rowels
rubels84112992rubels
ruers515019412ruers
rues46044482rue_s
rules55234252rules
ryes75529352rye_s
seals54839692seals
seeds64330062seeds
seeks94724642seeks
seel45042982seel_
seely84522632seely
seems75525022seems
seeps74828752seeps
seers55136382seers
sees45361052see_s
sells55134432sells
sels46345982_sels
speels85116392speels
steels64117982steels
streels73811342streels
taels56822072taels
teals56234132teals
teel46335802teel_
teems76019782teems
teens56227482teens
tees45353582tee_s
teles54536002teles
tells55828942tells
tels46841692_tels
treens65317872treens
trees55835762tree_s
unreels7258312unreels
veals84926192veals
veeps104715722veeps
veers84521362veers
vees75439432vee_s
veils84918802veils
weals85428742weals
wedels103811032wedels
weeds95222212weeds
weeks125017862weeks
weel75834082weel_
weens85224052weens
weeps104120562weeps
wees76249122wee_s
weets85427722weets
wells85426192wells
wheels123811712wheels
yells85821942yells
zeals145320852zeals
zees136331892zee_s

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.0961861364.6
2DLD Change Limit538002861.79629955.5
3Display Results2862860.0763763.2
 (SQL Overall)1786912861.96890798.3
 
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.