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

199 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
scrolled113705(None) 
strolled937821strolled
carolled1138832carolled
drolled93810222_drolled
enrolled967962enrolled
enscrolled1342552enscrolled
inscrolled1342252inscrolled
rerolled93010052rerolled
rolled74220242__rolled
schooled1447052schooled
scolded11358862sc_olded
scowled13398192sc_owled
scrawled1445922scrawled
scroll8310172scroll__
scrolls938062scroll_s
scrooped1356402scrooped
scrouged1235382scrouged
scrupled1335822scrupled
sculled102911692sc_ulled
shrilled1246862shrilled
stroller848182stroller
trolled84312262_trolled
unrolled9610412unrolled
bolled94722653__bolled
broiled103811423_broiled
called94126733_c_alled
caroled103717693caro_led
caroller1039203caroller
celled94420323_c_elled
chilled133310933_chilled
coaled95022713_c_oaled
coiled95123943_c_oiled
coled85540763_c_o_led
collet84030363_c_ollet
collied103316673_c_ollied
cooled95224593_c_ooled
cowled125218393_c_owled
craaled10339423_craaled
cradled113410813_cradled
crawled133710403_crawled
creeled104012013_creeled
croaked143710533_croaked
crocked164014433_crocked
crooked143910943_crooked
crooned103813343_crooned
cropped143812063_cropped
crossed105313893_crossed
crowded14418793_crowded
crowed124717303_cro_wed
crowned133912433_crowned
cruller968753_cruller
culled94022473_c_ulled
dolled83518073__dolled
drilled94711673_drilled
droller84110283_droller
drooled9369203_drooled
enrollee878343enrollee
enroller867183enroller
escrowed1434653escro_wed
extolled1654313extolled
frilled113911603_frilled
girolle835793girolle_
girolles935523girolles
grilled94012833_grilled
growled12278173_growled
jackrolled2452033jackrolled
knolled12296573_knolled
logrolled1142533logrolled
lolled74315823__lolled
muralled1136423muralled
outrolled1037433outrolled
paroled104217633paro_led
patrolled1245713patrolled
perilled11410113perilled
polled94022003__polled
prilled104713003_prilled
prowled13309913_prowled
repolled11359623repolled
reroller8258753reroller
rilled74525653__rilled
roiled74320053__roiled
rolfed104510523__rolfed
roller63919793__roller
scabbled15156303scabbled
scalded11409763sc_alded
scaled94822443sc__aled
scalped124411993sc_alped
schiller13296473schiller
scoffed16266183sc_offed
scold85414863sc_o_l_d
scolder103210343sc_older
scolex1538243sc_o_lex
scollop11275433sc_ollop
scolloped1443653sc_olloped
sconced12359173sc_onced
scooched16206683scooched
scooped124611743sc_ooped
scooted103612283sc_ooted
scoped115116653sc_o_ped
scorched16187193scorched
scored94621133sc_o_red
scorned10229953sc_orned
scoured103811153sc_oured
scouted104112033sc_outed
scowed124413833sc_o_wed
scowler12248193sc_owler
scrabbled16154973scrabbled
scragged1335823scragged
scrambled16164813scrambled
scrammed1555003scrammed
scraped124313133scr_aped
scrapped1556533scrapped
scrawler1345893scrawler
screaked15246983screaked
screamed13277603screamed
screed95718933scr__eed
screeded1235643screeded
screened1137413screened
screwed135710663scr_ewed
scribbled16174033scribbled
scribed124510643scr_ibed
scried95817303scr__ied
scrieved14366203scrieved
scrimped1555313scrimped
scripted13117553scripted
scrived134511113scr_ived
scrod85115073scro___d
scrolling12187803scrolling
scrooched1763843scrooched
scrooge1037183scrooge_
scrooges1137163scrooges
scrouge1036353scrouge_
scrouges1136683scrouges
scrounged1343143scrounged
scrubbed1533853scrubbed
scrummed1554313scrummed
scruple1137193scruple_
scruples1237433scruples
scuffled17256203scuffled
sculked14307183sc_ulked
sculler99812153sc_uller
sculped12398253sc_ulped
scumbled1535053scumbled
scuttled1134533scuttled
sepalled1156903sepalled
shelled113815093s_helled
shilled113313623s_hilled
shoaled113810973s_hoaled
shooled115212663s_hooled
shriller1136823shriller
shroffed1842563shroffed
shrouded1333603shrouded
skilled123110863s_killed
skoaled12226063s_koaled
skulled12317403s_kulled
smelled103511863s_melled
snelled83313053s_nelled
snooled84513943s_nooled
snoozled18344493snoozled
soiled73822473s__oiled
soled65835173s__o_led
soloed74515743s__oloed
solved105312933s__olved
souled75419823s__ouled
spalled103113133s_palled
spelled103714743s_pelled
spilled103613623s_pilled
spiralled1244403spiralled
spoiled104811353s_poiled
spooled104613523s_pooled
sprawled1434523sprawled
sprouted1136393sprouted
squalled1835943squalled
stalled83515693s_talled
stilled83314793s_tilled
stoled74521593s_to_led
stollen747593s_tollen
stooled84313893s_tooled
streeled9267873streeled
stroked124613623stro_ked
stroll6311603stroll__
strollers937553strollers
strolls739183stroll_s
stropped1367343stropped
strowed115312143stro_wed
stroyed114110863stro_yed
swelled113211703s_welled
swilled113611833s_willed
swollen1034263s_wollen
symbolled1742823symbolled
thralled1245803thralled
thrilled1235493thrilled
tolled73819033__tolled
trilled84116313_trilled
troller73913173_troller
trolley10328753_trolley
trollied935893_trollied
unpolled1168943unpolled
woolled1136643_woolled

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621997.06320694.0
3Display Results1991990.0762618.4
 (SQL Overall)1786911997.57523589.6
 
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.