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

170 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
reeled7472553(None) 
creeled104012011creeled
heeled104018411heeled
keeled114414271keeled
peeled94119711peeled
reeded84022561reeded
reefed103816581reefed
reeked113717641reeked
reeler63822571reeler
reeved104118711reeved
repled93319781repled
reveled113917751reveled
seeled73922091seeled
aneled74719282aneled
beefed123510872beefed
beeped115313452beeped
beetled1038222beetled
belled94626192belled
beveled133811132beveled
breezed19287052breezed
ceiled94114952ceiled
celled94420322celled
creeped12329712creeped
creneled11326892creneled
deeded94615542deeded
deemed104713062deemed
deled75326542_deled
develed123611932develed
dueled84813662dueled
feeler93215172feeler
feezed19439992feezed
felled103720302felled
fueled104913602fueled
geeked124510162geeked
gelled84718892gelled
greened93111262greened
greeted93111382greeted
grueled937132grueled
healed105121442healed
heeded114215762heeded
heeler93917312heeler
heezed194210512heezed
heiled104415612heiled
helled104024702helled
jeeped16469842jeeped
jeered143912792jeered
jelled144916062jelled
jeweled1845332jeweled
keeked104810122keeked
keened114013632keened
kneeled12328072kneeled
leered73816222leered
leveled114010382leveled
melled95023022melled
mewled123710052mewled
needed84114442needed
needled9358512needled
pealed95322812pealed
peeked134314582peeked
peeler83517382peeler
peened94318162peened
peeped113915392peeped
peered93819492peered
peeved124112892peeved
preened103214992preened
railed74727542railed
raveled114113632raveled
realer63528592realer
reales64934122reales
reamed94326122reamed
reaped94122452reaped
reared75930012reared
reaved104523922reaved
rebelled113110332rebelled
reblend1036652reblend
rebred95816352rebred
receded112713042receded
recked134821802recked
reclad9311872reclad
redded94019552redded
reddled102912322reddled
reded74829122r_eded
redleg839272redleg
redyed114611242redyed
reed55549622r_e_ed
reefer93314362reefer
reeker103715592reeker
reel45240532reel__
reelect911515632reelect
reelers73520272reelers
reels55333262reel_s
reested82916232reested
reeve84121322reeve_
reeves94721492reeves
refed93921922r_efed
refeed104717622refeed
refelled122810172refelled
reffed134712512reffed
refiled114318652refiled
reflet94024232reflet
reflew12389452reflew
reflex16359512reflex
refueled1286572refueled
regaled93615962regaled
reglet73724232reglet
reglued936332reglued
reheeled1236772reheeled
reined74425522reined
reived104518132reived
rekeyed1536162rekeyed
relend76116452relend
relet54749822r_elet
relied74926232relied
remelted11310152remelted
rended84524102rended
reneged92010762reneged
renewed11309992renewed
rented74426592rented
reoiled84316852reoiled
repealed113211872repealed
repelled113111592repelled
replead10399012replead
replied103914452replied
repped114616722repped
resealed92713972resealed
reseed74823292reseed
resewed113011822resewed
resiled84621982resiled
resoled84119282resoled
rested74430782rested
retied75924982retied
retiled84420512retiled
retted74826312retted
reused75419562reused
revealed123211212revealed
reveler104116342reveler
revelled123712742revelled
revered112819332revered
reviled114417922reviled
revved13469722revved
rewed95425452r_ewed
reweld103711112rewel_d
rewelded1335892rewelded
rifled104115002rifled
riled65833252r_iled
rilled74525652rilled
roiled74320052roiled
rolled74220242rolled
roweled11269862roweled
ruled65822522r_uled
sealed74328362sealed
seeded84520462seeded
seemed95117612seemed
seeped94317522seeped
speeled103712452speeled
steeled83513222steeled
streeled9267872streeled
teemed95114872teemed
trebled1038482trebled
unreeled91310332unreeled
vealed103916322vealed
veered103612742veered
veiled103714542veiled
wedeled1237782wedeled
weeded113914872weeded
weened104013732weened
weeted103913792weeted
welled103820212welled
wheeled14318462wheeled
yelled104116252yelled

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 Filter178691825510.343520965.0
2DLD Change Limit825511702.56332208.7
3Display Results1701700.0463695.7
 (SQL Overall)1786911702.95260532.2
 
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.