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

346 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
strolls73918(None) 
scrolls938061scrolls
stroll6311601stroll_
trolls64613941_trolls
atolls65511352at_olls
drolls75312392_drolls
enrolls7108092enrolls
outrolls847822outrolls
rerolls739942rerolls
rolls55326232__rolls
scroll8310172scroll_
shrills10389932shrills
stalls64019932st_alls
sterols7313442stero_ls
stills64118572st_ills
stoles63927672st_oles
stools65117022st_ools
streels73811342streels
strobes93813262strobes
strobils1046562strobils
strokes114316322strokes
strolled937822strolled
stroller848182stroller
strollers937552strollers
strops86220382stro_ps
strouds837802strouds
strows96718272stro_ws
stroys95914602stro_ys
stulls63912982st_ulls
tolls54728432_t_olls
trills64319852_trills
troll54416532_troll_
trolly94012362_trolly
trulls64110282_trulls
unrolls797792unrolls
astrally1148883astrally
astrals75515243astr_als
atoll57913923at_oll_
bedrolls1144673bedrolls
bolls75531313__bolls
brills84916293_brills
broils84114173_broils
brolly114510853_brolly
carols85124983caro_ls
carolus94612603carolus
corolla938623corolla
corollas1039213corollas
dolls66126923__dolls
drills74414203_drills
droll65415403_droll_
drolly105411673_drolly
drools74412813_drools
enroll61110073enroll_
enrols61213383enro_ls
enscrolls1192523enscrolls
estriols856253estriols
estrones8313323estrones
estrous7712533estro_us
extolls1444603extolls
frills94414223_frills
girolle835793girolle
girolles935523girolles
grills74314803_grills
growls104711113_growls
inscrolls11112483inscrolls
knolls10367413_knolls
krills104211283_krills
logrolls943373logrolls
lolls512121733__lolls
molls75129783__molls
nerolis71012773nerolis
nerols6914883nero_ls
ostioles839273ostioles
outpolls1046213outpolls
outroll749303outroll_
paroles95025883paroles
parols84722613paro_ls
patrols93513513patro_ls
payrolls1344753payrolls
petrols92913083petro_ls
polls74627723__polls
prills84015613_prills
proles84627203_proles
prowls115511083_prowls
pyrolas1239863pyrolas
quolls15327303_quolls
repolls939053repolls
reroll6412683reroll_
rills55032713__rills
roils54826793__roils
roles56747983__roles
rolfs84817123__rolfs
roll46331653__roll_
rotls55620163__rotls
safroles1136933safroles
safrols1036863safro_ls
salols64017873salo_ls
sarodes84216143sarodes
sarods74918573saro_ds
sarongs84511803sarongs
saros55238063saro__s
saroses73619333saroses
scalls84218203s_calls
schools1249113schools
schorls1248353schorls
scolds95011233s_colds
scowls11549593s_cowls
scrawls12177283scrawls
scrods94111613scro_ds
scrolled1137053scrolled
scroops11288253scroops
sculls84613883s_culls
sells55134433s__ells
serails73318363serails
serials73919743serials
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
servals103410743servals
shells94319523s_hells
sheols94614163sheo_ls
shills94519613s_hills
shoals94215793s_hoals
shools94919013s_hools
shorls94516203s_horls
shrill94712303shrill_
shrilly13318563shrilly
shroffs1634363shroffs
shrouds1136023shrouds
sills55135993s__ills
skells105013783s_kells
skills104313923s_kills
skoals10438243s_koals
skulls10429643s_kulls
smalls84514123s_malls
smells83914743s_mells
smolts84411883s_molts
snells64614203s_nells
snools65715883s_nools
soils55327983s__oils
sokols10399093soko_ls
soles55547923s__oles
solos54830793s__olos
sols45448163s__o_ls
solus54726983s__olus
sorels63921163sor_els
soroses73117483soroses
sorosis72611973sorosis
sorrels7310723sorrels
sotols63714473soto_ls
souls55127363s__ouls
spalls84217343s_palls
spells84617683s_pells
spills84717463s_pills
spoils84614533s_poils
spools85115913s_pools
sprawls12176373sprawls
sprouts949983sprouts
squalls1647313squalls
squills1666313squills
stables93219073stables
stales65538293st_ales
stalks104614553st_alks
stall54722353st_all_
stanols739733stanols
staples93617213staples
startles82111963startles
steals64020063st_eals
steamrolls1251813steamrolls
steels64117983st_eels
steles63725663st_eles
stella63612973st_ella
stellas72813043stellas
steroids9911443steroids
sterol6613333stero_l_
stifles103013393stifles
stiles64328773st_iles
still54922083st_ill_
stilly93714093st_illy
stilts67915313st_ilts
stipels9418953stipels
stoas55126023st_o_as
stoats65117483st_oats
stobs75718233st_o_bs
stocks124715633st_ocks
stoics8311113st_oics
stokes104821793st_okes
stole54928813st_o_le
stoled74521593st_oled
stolen64315063st_olen
stolid74213183st_olid
stollen747593st_ollen
stollens835293st_ollens
stolon64112073st_olon
stolons73410243st_olons
stomas84816323st_omas
stomps105612833st_omps
stones65130033st_ones
stooges83611483stooges
stooks105115373st_ooks
stool55619893st_ool_
stooled84313893stooled
stoolie739723stoolie
stoolies8311083stoolies
stoops85917893st_oops
stopes84525893st_opes
stops74827283st_o_ps
storers75018683storers
stores65533663st_ores
storeys10559653storeys
stories7324273stories
storks106115953st_orks
storms85814633st_orms
stoss54316343st_o_ss
stots54828553st_o_ts
stotts64612863st_otts
stoups85313273st_oups
stours65015633st_ours
stouts65019003st_outs
stoves93818923st_oves
stowps115710583st_owps
stows86622703st_o_ws
strafes104516003strafes
strains74218153strains
straits74916323straits
strakes114218073strakes
strands83711953strands
straps87721783str_aps
strass67117223str_ass
stratas73013583stratas
straths102711723straths
stratus73011733stratus
straws98718673str_aws
strays96417933str_ays
streaks114411273streaks
streams94713373streams
streeks11378713streeks
streel64214023streel_
streets73312613streets
streps86218063str_eps
stress66616673str_ess
strews96817103str_ews
stricks134310693stricks
strides84520393strides
strifes104716583strifes
strigils946853strigils
strikes114719093strikes
strings84617133strings
stripes95320573stripes
strips85719653str_ips
strives104119373strives
strobe84513813stro_be
strobic1138253strobic
strobil936963strobil
strobila1044933strobila
strobile1047033strobile
strobiles1146953strobiles
strobili1044933strobili
strobilus1143613strobilus
strode75215973stro_de
stroke105116173stro_ke
stroked124613623stroked
stroker114113523stroker
strokers123910903strokers
strolling10238793strolling
stroma84313073stro_ma
stromal93010593stromal
strong74914883stro_ng
strongly1245953strongly
strongyls1343153strongyls
strook10410303stro_ok
strop77422243stro__p
strophe1239143strophe
strophes13310603strophes
stroppy14205093stroppy
stroud7310383stro_ud
strove95014793stro_ve
strow88920573stro__w
strowed115312143strowed
strown96812093stro_wn
stroy87720393stro__y
stroyed114110863stroyed
stroyer103510783stroyer
stroyers11388923stroyers
strudels934123strudels
strumas9419833strumas
strums84716453str_ums
strunts7429543strunts
struts65616803str_uts
stull54916273st_ull_
styles94418653st_yles
stylus9397463st_ylus
surplus936793surplus
swells93913983s_wells
swills94213363s_wills
talls55133433_t_alls
tells55828943_t_ells
thills95515383_thills
tholes94919783_tholes
tholos94213003_tholos
thralls10299043thralls
thrills10398783thrills
tills54631713_t_ills
toils54527493_t_oils
tolas54532773_t_olas
toles55147133_t_oles
toll45535263_t_oll_
tolus55024483_t_olus
tolyls9436963_t_olyls
tools55325243_t_ools
trails64622513_trails
trawls94412393_trawls
trellis739873_trellis
trials64319883_trials
trill55122933_trill_
triols66117803_triols
troaks104410603_troaks
trocks123614633_trocks
trogs67022603_tro_gs
troilus736413_troilus
trois57226093_tro_is
trokes104019263_trokes
trolled84312263_trolled
troller73913173_troller
trollers83211213_trollers
trolley10328753_trolley
trolleys11315693_trolleys
trollies8310233_trollies
trollop944793_trollop
trollops1044813_trollops
tromps104911703_tromps
tronas63816903_tronas
trones65629283_trones
troops85712783_troops
tropes84824353_tropes
troths95414153_troths
trots56629943_tro_ts
trotyls10236033_trotyls
trouts66116633_trouts
troves94719113_troves
trowels10358363_trowels
trows88826183_tro_ws
troys86418613_tro_ys
trull54012673_trull_
twills9489793_twills
unroll61210073unroll_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273466.45320769.7
3Display Results3463460.1232813.0
 (SQL Overall)1786913466.98225593.1
 
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.