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

398 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
sprout841940(None) 
spout75029631sp_out
sprouts949981sprouts
grout65330422_grout
pout65752552_p_out
prost75434102_prost
proud84615482_proud
resprout1078782resprout
rout46153282__rout
scout75031452s_cout
serous65023562serous
setout64719472setout
shout85433172s_hout
shroud1038772shroud
snout54530632s_nout
spinout9311582spinout
sport75935982sp_ort
spot65540692sp_o_t
spouts85115112sp_outs
sprat76635972spr_at
sprent84522382sprent
sprint84526792sprint
sprit76736402spr_it
sprouted1136392sprouted
sprue74717632spr_ue
sprug85313892spr_ug
stout57434052s_tout
stroud7310382stroud
strut56030732str_ut
surtout7411682surtout
trout57332572_trout
uproot8314122uproot
about75229083_about
adroit7518793adroit
aport75432173ap_ort
apron7318833apro_n
aprons8316993aprons
aurous64119263aurous
barbut104617003barbut
bout66353293__bout
brut66537963_br_ut
bugout9311863bugout
burgout1049773burgout
burnout9310453burnout
buyout11310103buyout
cerous85821203cerous
clout75330463_clout
copout10418783copout
croft105622683_croft
croup95616783_croup
croute84617273_croute
cuprous1149743cuprous
cutout8315923cutout
devout10712993devout
dimout9414243dimout
droit65127123_droit
dropt86924433_dropt
drouk1039433_drouk
drouth104410103_drouth
dugout8310363dugout
enroot6615993enroot
esprit8312843espr_it
estrous7712533estrous
flout86226203_flout
front85029223_front
frost84727833_frost
glout65925813_glout
gout56646003__gout
groat65531973_groat
grot55942053_gro_t
group85413923_group
grouts75015613_grouts
grouty104710983_grouty
knout95018263_knout
kraut95221403_kraut
layout9513703layout
leprous938843leprous
lirot5430033liro_t
lout45952143__lout
mahout11415813mahout
out38072153___out
parous84024163parous
payout11714653payout
phot95534363_pho_t
phut96925973_p_hut
pigout9314613pigout
pious74621273_pious
plot66141233_plo_t
poet65552903_p_oet
porous84419483porous
port66059633_p_ort
post67953363_p_ost
pot58078433_p_o_t
pouf95732643_p_ouf
poult76928873_p_oult
pour611527473_p_our
pouts75530323_p_outs
pouty107018813_p_outy
prat65952043_pr_at
prau66529473_prau_
praus74621753_praus
precut102016533_precut
prest75736353_prest
print74837463_print
pro55837263_pro__
proa66229963_pro_a
proas75028803_proas
probe94320813_probe
probit103218353_probit
prod76129503_pro_d
prods85523553_prods
product1279233_product
proem94818273_proem
prof96134663_pro_f
profit113016273_profit
profs105120893_profs
prog75729003_pro_g
progs86624153_progs
progun968783_progun
projet15315183_projet
prole74527793_prole
prom87631703_pro_m
promo95620003_promo
prompt12313013_prompt
proms95426413_proms
prone75332623_prone
prong85218113_prong
pronto8313993_pronto
proof105221533_proof
prop85932813_pro_p
props95726883_props
pros65742783_pro_s
prose75835123_prose
prosit85124593_prosit
proso77222413_proso
pross76529403_pross
prosy106319253_prosy
prove104823193_prove
prow97030383_pro_w
prowl105615123_prowl
prows106327013_prows
proxy175011013_proxy
pruta7314243_pr_uta
put55759073_p__ut
putout8315113putout
ragout7317183ragout
redout71820253redout
reroute7313963reroute
resprouts1174823resprouts
root45655923__root
rot37282953__ro_t
roue45941743__roue
roup66627693__roup
roust55532063__roust
route55132073__route
routh86423073__routh
routs57133413__routs
roux117419363__roux
rubout8313563rubout
runout6414873runout
rut35560523__r_ut
sabot7931783sabo_t
sacbut10811943sacbut
sagbut959753sagbut
sajou12311693sajou_
sajous13310583sajous
saporous1039053saporous
sapour83812373sapour
saprobe1137333saprobe
sarcous9312933sarcous
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
savour94110703savour
scoot75729153s_coot
scot66242613s_co_t
scour75315533s_cour
scouth115011153s_couth
scouts84817943s_couts
script105717903script
scrod85115073scro_d
scrods94111613scrods
scroll8310173scroll
scroop10299783scroop
scrota8310203scrota
scrotum1145133scrotum
scrouge1036353scrouge
scrub94914203scr_ub
scrum95418203scr_um
scut65835543s__cut
seatrout8411593seatrout
sellout7313583sellout
serest64831613serest
serious73616283serious
serosa6313023serosa
serow86720443sero_w
serows96016393serows
serum75223473ser_um
setous64917373setous
setouts74110333setouts
sheroot10414373sheroot
shoat85633953s_hoat
shoot84235913s_hoot
short85040533s_hort
shot76150263s_ho_t
shott85332193s_hott
shouts94017723s_houts
shrift12413543shrift
shroff1538503shroff
shrouds1136023shrouds
shrove125412233shrove
shrub104814893shr_ub
shrug94512513shr_ug
shut76137593s__hut
shutout1048533shutout
sickout1359373sickout
sirup74014913sir_up
skort94925643s_kort
slipout949083slipout
slot46049833s_lo_t
slut45040593s__lut
smolt74824163s_molt
smut66629783s__mut
snoot55030143s_noot
snort54833753s_nort
snot44745453s_no_t
snouts64915873s_nouts
snouty9419953s_nouty
soft76942823s__oft
soot45761063s__oot
sorbet83924083sorbet
sorest65028003sorest
sort46264813s__ort
sorus54527583sor_us
sot310384303s__o_t
sou37853693s__ou_
souk86127173s__ouk
soul46435713s__oul
soup66232913s__oup
sour45935893s__our
sous46947213s__ous
south85223573s__outh
spait75631603sp_ait
sparest94616433sparest
sparoid102311543sparoid
spat66548523sp__at
spelt75430193sp_elt
spent75532833sp_ent
spermous1247933spermous
spigot9312603spigot
spilt75532223sp_ilt
spinet85629753spinet
spinous9310443spinous
spinouts1036023spinouts
spirant9814293spirant
spirit83519923spirit
spiroid10219823spiroid
spirt75032953sp_irt
spit65545083sp__it
splat76129343sp_lat
splent84720193splent
splint85223283splint
split75729013sp_lit
splore81611303splore
splosh1186543splosh
spode84617703sp_ode
spoil75818653sp_oil
spoilt85016593spoilt
spoke114818663sp_oke
spoof105019013sp_oof
spoofs114011813spoofs
spoofy14498553spoofy
spook115416043sp_ook
spooks124312933spooks
spooky15418093spooky
spool75219043sp_ool
spools85115913spools
spoon74719443sp_oon
spoons84116023spoons
spoony114111793spoony
spoor75016353sp_oor
spoors84014033spoors
sporal82915453sporal
spore75428593sp_ore
spored94821793spored
spores84726613spores
sporoid102310733sporoid
sports84619183sports
sporty115112493sporty
sporule937273sporule
spots74424113sp_ots
spotty11448583sp_otty
spouse84112513sp_ouse
spouted103412263sp_outed
spouter94213223sp_outer
sprag86418693spr_ag
sprags95715823sprags
sprain83614863sprain
sprang95713523sprang
sprats85819933sprats
sprawl11188063sprawl
spray106720063spr_ay
sprays115913643sprays
spread9312533spread
spree74830863spr_ee
sprees85620643sprees
sprier84119063sprier
spriest92718653spriest
sprig85617743spr_ig
spright132010403spright
sprigs94814773sprigs
spring94526013spring
sprints94113773sprints
sprite84421773sprite
sprits85122533sprits
spritz174714423spritz
sprocket1646773sprocket
sprouting1236943sprouting
spruce103910873spruce
sprucy13356323sprucy
sprues84515763sprues
sprugs94010173sprugs
sprung94610033sprung
spry96819123spr__y
spryer11418533spryer
spryest12247813spryest
spryly1435513spryly
spud75818493sp__ud
spue66025523sp__ue
spumous1135853spumous
spun66221463sp__un
spur65321193sp__ur
spurious1036963spurious
spurt77227983sp_urt
sputa74612963sp__uta
sputum1035943sputum
stoat57135953s_toat
stopt76528353s_topt
stot46347333s_to_t
stott56929793s_tott
stoup75517073s_toup
stour54916743s_tour
stouts65019003s_touts
strait64025893strait
street64125773street
strict84821043strict
stript85222193stript
strobe84513813strobe
strode75215973strode
stroke105116173stroke
stroll6311603stroll
stroma84313073stroma
strong74914883strong
strook10410303strook
strop77422243stro_p
strops86220383strops
strouds837803strouds
strove95014793strove
strow88920573stro_w
strown96812093strown
strows96718273strows
stroy87720393stro_y
stroys95914603stroys
strum75619453str_um
strunt64918913strunt
struts65616803str_uts
support11310523support
surcoat9412923surcoat
surest65026763surest
surmount1045903surmount
surtouts846203surtouts
swot75134663s_wo_t
swoun84811493s_woun
syrup103010963syr_up
taproot9412673taproot
tarot55943933taro_t
throat94819753throat
torot56139943toro_t
torous64319033torous
tout46753823__tout
trot46351313_tro_t
trouts66116633_trouts
trouty95211793_trouty
tryout9410763tryout
turnout7410283turnout
unroot6315553unroot
upcourt1146103upcourt
upfront1246973upfront
upmost1068193upmost
uproar8106933uproar
uproots937143uproots
uprose82311483uprose
uprouse937223uprouse
vrouw11507343_vrouw
wipeout1287873wipeout
workout1448393workout

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127163985.65619928.6
3Display Results3983980.1103618.2
 (SQL Overall)1786913986.15629027.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.