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

234 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
strolled93782(None) 
scrolled1137061scrolled
stroller848181stroller
trolled84312261_trolled
carolled1138832carolled
drolled93810222_drolled
enrolled967972enrolled
outrolled1037432outrolled
patrolled1245712patrolled
rerolled93010062rerolled
rolled74220242__rolled
shrilled1246862shrilled
stalled83515692st_alled
stilled83314792st_illed
stoled74521592st_o_led
stollen747592st_ollen
stooled84313892st_ooled
streeled9267872streeled
stroked124613622stro_ked
stroll6311602stroll__
strollers937562strollers
strolls739182stroll_s
stropped1367352stropped
strowed115312142stro_wed
stroyed114110862stro_yed
tolled73819032_t_olled
trilled84116312_trilled
troller73913172_troller
trolley10328752_trolley
trollied935902_trollied
unrolled9610412unrolled
bolled94722653__bolled
broiled103811423_broiled
caroled103717693caro_led
caroller1039203caroller
controlled1345383controlled
dolled83518073__dolled
drilled94711673_drilled
droller84110283_droller
drooled9369203_drooled
enrollee878343enrollee
enroller867183enroller
enscrolled1342563enscrolled
extolled1654313extolled
frilled113911603_frilled
girolle835793girolle_
girolles935523girolles
grilled94012833_grilled
growled12278173_growled
inscrolled1342263inscrolled
knolled12296573_knolled
logrolled1142533logrolled
lolled74315823__lolled
muralled1136423muralled
outpolled1246173outpolled
paroled104217633paro_led
patroller1145753patroller
perilled11410113perilled
pistolled1255173pist_olled
polled94022003__polled
prilled104713003_prilled
prowled13309913_prowled
repolled11359623repolled
reroller8258753reroller
rilled74525653__rilled
roiled74320053__roiled
rolfed104510523__rolfed
roller63919793__roller
schooled1447053schooled
scolded11358863s_colded
scowled13398193s_cowled
scrawled1445923scrawled
scroll8310173scroll__
scrolls938063scroll_s
scrooped1356413scrooped
scrouged1235393scrouged
scrupled1335833scrupled
sculled102911693s_culled
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
stabled103514953st_abled
staled74728103st__aled
stalked123811173st_alked
stapled103613703st_apled
startled9208563startled
steamrolled1451383steamrolled
steeled83513223st_eeled
steepled1135903steepled
stickled15298973stickled
stifled113511093st_ifled
stiller73414303st_iller
stilted83511473st_ilted
stippled1345303stippled
stipuled1134453stipuled
stobbed12287493st_obbed
stocked144312873st_ocked
stodged10377983st_odged
stoked114718293st_o_ked
stole54928813st_o_le_
stolen64315063st_o_len
stoles63927673st_o_les
stolid74213183st_o_lid
stollens835293st_ollens
stomped124110533st_omped
stoned75923143st_o_ned
stooged94310733st_ooged
stooked124312303st_ooked
stoolie739723stoolie_
stoolies8311083stoolies
stooped103813833st_ooped
stoped94721013st_o_ped
stopped124512203st_opped
stoppled1345003stoppled
stored75524213st_o_red
storeyed1234643storeyed
storied8515163st_oried
stormed1039043st_ormed
stotted83511423st_otted
stowed105817203st_o_wed
straddled12205023straddled
strafed114413333str_afed
straggled12296853straggled
strained9412253strained
straked125415343str_aked
stranded102710813stranded
strangled11268983strangled
strapped1357823strapped
strawed114813623str_awed
strayed114513283str_ayed
streaked13228453streaked
streamed11258903streamed
streeked13246153streeked
stressed9128543stressed
strewed115811343str_ewed
striated93414153striated
strickled1665833strickled
stringed102911873stringed
striped105214363str_iped
stripped1357093stripped
strived114713663str_ived
strobe84513813stro_be_
strobes93813263stro_bes
strobile1047033strobile_
strobiles1146953strobiles
strode75215973stro_de_
stroke105116173stro_ke_
stroker114113523stro_ker
strokes114316323stro_kes
strolling10238793strolling
stronger9349703stronger
strophe1239143strophe_
strophes13310603strophes
stropper1247763stropper
stroud7310383stro__ud
strove95014793stro_ve_
stroyer103510783stro_yer
struggled12304303struggled
strummed1344473strummed
strunted957243strunted
strutted946343strutted
stubbled1385073stubbled
stumbled1335623stumbled
styled105613103st__yled
swelled113211703s_welled
swilled113611833s_willed
swollen1034263s_wollen
symbolled1742823symbolled
tholed105113873_tho_led
thralled1245803thralled
thrilled1235493thrilled
tilled74722953_t_illed
toiled74420323_t_oiled
toled65934923_t_o_led
toller63819443_t_oller
tooled74918903_t_ooled
tootled83511043_tootled
trailed83415673_trailed
trawled113411523_trawled
trebled1038483_trebled
trifled113711963_trifled
triller74215893_triller
tripled104113833_tripled
troaked12438253_troaked
trocked144312243_trocked
troked114114583_tro_ked
troland837543_troland
troll54416533_troll__
trollers83211213_trollers
trolleyed1342473_trolleyed
trolleys11315693_trolleys
trollies8310233_trollies
trollop944793_trollop
trolls64613943_troll_s
trolly94012363_troll_y
tromped124210293_tromped
trooped104010723_trooped
trothed114010973_trothed
trotted83711283_trotted
troubled1134983_troubled
trouped103910983_trouped
trowed104714653_tro_wed
troweled12106113_troweled
trowelled1344443_trowelled
twilled11398033_twilled
unpolled1168943unpolled
vitriolled1451663vitriolled
woolled1136643_woolled

Search took 10 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.423422437.4
2DLD Change Limit1461622348.56017075.0
3Display Results2342340.0962437.5
 (SQL Overall)1786912349.07919681.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.