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

206 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
stroller84817(None) 
strolled937811strolled
strollers937541strollers
troller73913171_troller
caroller1039202caroller
droller84110282_droller
enroller867182enroller
patroller1145742patroller
reroller8258752reroller
roller63919792__roller
scrolled1137052scrolled
shriller1136822shriller
stiller73414292st_iller
stollen747582st_ollen
stroker114113522stro_ker
stroll6311602stroll__
strolls739182stroll_s
stronger9349692stronger
stropper1247762stropper
stroyer103510782stro_yer
toller63819442_t_oller
triller74215892_triller
trolled84312262_trolled
trollers83211212_trollers
trolley10328752_trolley
astrologer1153603astrologer
broiler92911753_broiler
caroler93816753caro_ler
carolled1138833carolled
carollers1137703carollers
controller1245523controller
cruller968753_cruller
driller84311883_driller
drolled93810223_drolled
drollery12314793_drollery
enrolled967963enrolled
enrollee878343enrollee
enrollers976173enrollers
extoller1564173extoller
friller104111743_friller
girolle835793girolle_
girolles935523girolles
griller84513353_griller
growler11318973_growler
holler93520613__holler
knoller11285913_knoller
kruller1145153_kruller
logroller1042443logroller
loller63315283__loller
outrolled1037433outrolled
patrolled1245713patrolled
patrollers1244813patrollers
poller83921853__poller
prowler123310013_prowler
rerolled93010053rerolled
rerollers9207123rerollers
rolfer94412273__rolfer
rolled74220243__rolled
rollers73117473__rollers
schiller13296473schiller
scolder103210343s_colder
scowler12248193s_cowler
scrawler1345893scrawler
scroll8310173scroll__
scrolls938063scroll_s
sculler99812153s_culler
seller63824593s__eller
sheller103515883s_heller
shoaler102610083s_hoaler
shrilled1246863shrilled
siller64026063s__iller
smaller93410333s_maller
smeller94212783s_meller
smolder10327753s_molder
sneller73512843s_neller
solder73921343s__older
solver94016703s__olver
spaller92713473s_paller
speller95415143s_peller
spiller92914333s_piller
spoiler93310683s_poiler
spooler93711383s_pooler
sprawler1334653sprawler
squaller1736083squaller
stabler94014933st_abler
staler64025823st__aler
stalker113912253st_alker
stalled83515683st_alled
stapler93913633st_apler
startler8248793startler
stealer72913973st_ealer
steamroller1351533steamroller
steelier839183steelier
stellar72610423st_ellar
stickler14259573stickler
stifler102911473st_ifler
stilled83314783st_illed
stillier868823stillier
stippler1235543stippler
stocker133713083st_ocker
stoker104417623st_o_ker
stole54928813st_o_le_
stoled74521593st_o_led
stolen64315063st_o_len
stoles63927673st_o_les
stolider936603st_olider
stollens835293st_ollens
stomper114111233st_omper
stoner65823203st_o_ner
stonier72013793st_onier
stooker113811733st_ooker
stooled84313893st_ooled
stoolie739723stoolie_
stoolies8311083stoolies
stooper93813193st_ooper
stoper84320103st_o_per
stopper113012603st_opper
storer64721673st_o_rer
stormier1036103stormier
stouter74012053st_outer
stover94115643st_o_ver
straddler11205113straddler
strafer103912463str_afer
straggler11377293straggler
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strangler10369473strangler
strapper1258093strapper
strawier1137493strawier
strayer104312503str_ayer
streaker12229483streaker
streamer10239513streamer
streeker12206643streeker
streeled9267863streeled
strewer104310413str_ewer
stricter1039423stricter
strider84315723str_ider
striker113714173str_iker
stringer93812943stringer
striper94514793str_iper
stripier1058863stripier
stripper1247123stripper
striver104315203str_iver
strobe84513813stro_be_
strobes93813263stro_bes
strobilar1143023strobilar
strobile1047033strobile_
strobiles1146953strobiles
strode75215973stro_de_
stroke105116173stro_ke_
stroked124613623stro_ked
strokers123910903stro_kers
strokes114316323stro_kes
strolling10238793strolling
strophe1239143strophe_
strophes13310603strophes
stropped1367343stropped
stroppers1356713stroppers
stroppier1364453stroppier
strove95014793stro_ve_
strowed115312143stro_wed
stroyed114110863stro_yed
stroyers11388923stro_yers
struggler11264553struggler
strummer1234783strummer
strutter846503strutter
studlier935473studlier
stumbler1235813stumbler
styler94013303st__yler
surlier72915443sur_lier
sweller103012463s_weller
swiller103211663s_willer
swollen1034263s_wollen
taller63721963_t_aller
teller63519813_t_eller
thriller1165553thriller
tiller64222543_t_iller
toiler63918283_t_oiler
tolled73819033_t_olled
tollers73217463_t_ollers
tooler63818613_t_ooler
tootler73511123_tootler
trailer73015393_trailer
trawler104011903_trawler
trifler103912153_trifler
trilled84116313_trilled
trillers83613493_trillers
troffer13125863_troffer
troll54416533_troll__
trolleys11315693_trolleys
trollied935893_trollied
trollies8310233_trollies
trollop944793_trollop
trolls64613943_troll_s
trolly94012363_troll_y
trooper94210363_trooper
trotter73312253_trotter
troubler1035293_troubler
trouper93811433_trouper
trouser73812473_trouser
trover95014663_tro_ver
troweler11106063_troweler
troweller1244563_troweller
unrolled9610413unrolled

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.423422437.4
2DLD Change Limit1461622067.47019566.5
3Display Results2062060.0762710.5
 (SQL Overall)1786912067.96922423.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.