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

343 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
sprouts94998(None) 
spouts85115111sp_outs
sprout8419401sprout_
grouts75015612_grouts
pouts75530322_p_outs
resprouts1174822resprouts
routs57133412__routs
scouts84817942s_couts
serous65023562serou_s
setouts74110332setouts
shouts94017722s_houts
shrouds1136022shrouds
snouts64915872s_nouts
spinouts1036022spinouts
sports84619182sp_orts
spots74424112sp_o_ts
spout75029632sp_out_
sprats85819932spr_ats
sprints94113772sprints
sprits85122532spr_its
sprouted1136392sprouted
sprues84515762spr_ues
sprugs94010172spr_ugs
stouts65019002s_touts
strouds837802strouds
struts65616802str_uts
surtouts846202surtouts
trouts66116632_trouts
uproots937142uproots
aprons8316993apro_ns
apropos1138843apropos
aurous64119263aurou_s
barbuts11439843barbuts
bouts75131313__bouts
bruts75922953_br_uts
bugouts1036193bugouts
burgouts1145123burgouts
burnouts1045263burnouts
buyouts1235203buyouts
cerous85821203cerou_s
clouts87017203_clouts
copouts11311083copouts
crofts114910593_crofts
croups104312553_croups
croute84617273_croute
croutes94815653_croutes
cuprous1149743cuprou_s
cutouts938033cutouts
dimouts1037893dimouts
droits74314313_droits
drouks1137123_drouks
drouth104410103_drouth
drouths11436483_drouths
dugouts935043dugouts
enroots738713enroots
esprits938393espr_its
estrous7712533estrou_s
flouts94315273_flouts
fronts94415793_fronts
frosts94214623_frosts
glouts74414713_glouts
gouts64826173__gouts
groats74816653_groats
grots65025853_gro_ts
groups94210513_groups
grout65330423_grout_
grouty104710983_grouty
knouts10438313_knouts
krauts10418513_krauts
layouts1046483layouts
leprous938843leprou_s
louts56330273__louts
mahouts1237143mahouts
outs45746963___outs
parous84024163parou_s
payouts1247303payouts
phots105418503_pho_ts
phuts104613503_p_huts
pigouts1037593pigouts
pious74621273_piou_s
plots75025673_plo_ts
poets76024443_p_oets
porous84419483porou_s
ports75934593_p_orts
posts75228783_p_osts
pots66452363_p_o_ts
poufs105616063_p_oufs
poults84613483_p_oults
pours74623183_p_ours
pout65752553_p_out_
pouty107018813_p_outy
prats76333393_pr_ats
praus74621753_prau_s
precuts111710473_precuts
prests84021263_prests
prints84320103_prints
proas75028803_pro_as
probes104119453_probes
probits112712573_probits
prods85523553_pro_ds
products1376513_products
proems104711163_proems
profits122911243_profits
profs105120893_pro_fs
progs86624153_pro_gs
projets1639163_projets
proles84627203_proles
promos105116423_promos
prompts1337473_prompts
proms95426413_pro_ms
prongs94314483_prongs
pronto8313993_pronto
proofs114511683_proofs
props95726883_pro_ps
pros65742783_pro__s
proses84733473_proses
prosos85718553_prosos
pross76529403_pro_ss
prost75434103_prost_
proud84615483_prou_d
proves114322253_proves
prowls115511083_prowls
prows106327013_pro_ws
pruta7314243_pr_uta
putouts937083putouts
puts65641753_p__uts
ragouts838543ragouts
redouts81411663redouts
reroute7313963reroute
reroutes8312223reroutes
resprout1078783resprout_
roots55933673__roots
rots46454093__ro_ts
roues56039353__roues
roups75118903__roups
roust55532063__roust
rousts617016723__rousts
rout46153283__rout_
route55132073__route
routes66129313__routes
routh86423073__routh
rouths95416823__rouths
rubouts937983rubouts
runouts737353runouts
ruts44541493__r_uts
sabots8314703sabo_ts
sacbuts1166473sacbuts
sagbuts1065223sagbuts
sajous13310583sajou_s
saporous1039053saporou_s
sapours93610623sapours
saprobes1237033saprobes
sarcous9312933sarcou_s
sarodes84216143sarodes
sarods74918573saro_ds
sarongs84511803sarongs
saros55238063saro__s
saroses73619333saroses
savours10389343savours
scoots85315943s_coots
scots74025913s_co_ts
scours84913593s_cours
scout75031453s_cout_
scouth115011153s_couth
scouths12527893s_couths
scripts11509373scripts
scrods94111613scro_ds
scrolls938063scrolls
scroops11288253scroops
scrota8310203scro_ta
scrotum1145133scrotum
scrotums1243983scrotums
scrouge1036353scrouge
scrouges1136683scrouges
scrubs104210313scr_ubs
scrums104614253scr_ums
scuts74522523s__cuts
seatrouts946393seatrouts
sellouts837493sellouts
serious73616283seriou_s
serosas7312663serosas
serows96016393sero_ws
serums83916303ser_ums
setous64917373setou_s
setout64719473setout_
sheroots1137863sheroots
shoats94117083s_hoats
shoots94619363s_hoots
shorts95321743s_horts
shots84730853s_ho_ts
shotts93614703s_hotts
shout85433173s_hout_
shrifts1335963shrifts
shroffs1634363shroffs
shroud1038773shrou_d
shrubs11409213shr_ubs
shrugs10469163shr_ugs
shutouts1143823shutouts
shuts85622483s__huts
sickouts1455503sickouts
sirups83710533sir_ups
skorts104211303s_korts
slipouts1044893slipouts
slots54830533s_lo_ts
sluts54523983s__luts
smolts84411883s_molts
smuts75415713s__muts
snoots64216683s_noots
snorts64116503s_norts
snots55225123s_no_ts
snout54530633s_nout_
snouty9419953s_nouty
softs85019233s__ofts
soots55536213s__oots
sorbets93012513sorbets
soroses73117493soroses
sorosis72611973sorosis
sorts54536663s__orts
sorus54527583sor_u_s
sots45552453s__o_ts
souks94820523s__ouks
souls55127363s__ouls
soups75322943s__oups
sours55230503s__ours
sous46947213s__ou_s
south85223573s__outh
souths95216603s__ouths
spaits85017473sp_aits
sparoids11218713sparoids
spats75031383sp__ats
spelts84614643sp_elts
spermous1247933spermou_s
spigots1037793spigots
spinets94714813spinets
spinous9310443spinou_s
spinout9311583spinout_
spirants1088283spirants
spirits94112623spirits
spirts85317133sp_irts
spits74429553sp__its
splats84817303sp_lats
splents93912133splents
splints94511743splints
splits85416413sp_lits
splores91910953splores
spodes94817433sp_odes
spoils84614533sp_oils
spokes124417213sp_okes
spoofs114011813sp_oofs
spooks124312933sp_ooks
spools85115913sp_ools
spoons84116023sp_oons
spoors84014033sp_oors
spores84726613sp_ores
sport75935983sp_ort_
sporty115112493sp_orty
sporule937273sporule
sporules1037703sporules
spot65540693sp_o_t_
spotty11448583sp_otty
spouse84112513sp_ouse
spouses92912813sp_ouses
spouted103412263sp_outed
spouter94213223sp_outer
spouters104011163sp_outers
sprags95715823spr_ags
sprains93013593sprains
sprangs104610053sprangs
sprat76635973spr_at_
sprawls12176373sprawls
sprays115913643spr_ays
spreads1039763spreads
sprees85620643spr_ees
sprent84522383sprent_
spriest92718653spriest
sprights14167143sprights
sprigs94814773spr_igs
springs104415923springs
sprint84526793sprint_
sprit76736403spr_it_
sprite84421773spr_ite
sprites94220333sprites
spritz174714423spr_itz
sprockets1743253sprockets
sprouting1236943sprouting
spruce103910873spr_uce
spruces113810503spruces
sprucy13356323spr_ucy
sprue74717633spr_u_e
sprug85313893spr_u_g
sprung94610033spr_ung
spryest12247813spryest
spuds85113673sp__uds
spues75025383sp__ues
spumous1135853spumou_s
spurious1036963spuriou_s
spurs74621523sp__urs
spurts84814973sp_urts
sputa74612963sp__uta
stoats65117483s_toats
stots54828553s_to_ts
stotts64612863s_totts
stoups85313273s_toups
stours65015633s_tours
stout57434053s_tout_
straits74916323straits
stratus73011733stratus
streets73312623streets
strobes93813263strobes
strokes114316323strokes
strolls739183strolls
strops86220383stro_ps
stroud7310383strou_d
strows96718273stro_ws
stroys95914603stro_ys
strums84716453str_ums
strunts7429543strunts
strut56030733str_ut_
supports1246513supports
surcoats1047943surcoats
surmounts1143443surmounts
surtout7411683surtout_
swots85518433s_wo_ts
swouns9358243s_wouns
syrups11277953syr_ups
taproots1047253taproots
tarots66422993taro_ts
throats104612193throats
torous64319033torou_s
touts54830393__touts
trots56629943_tro_ts
trout57332573_trout_
trouty95211793_trouty
tryouts1035313tryouts
turnouts845413turnouts
unroots738563unroots
uproars986453uproars
uproot8314123uproot_
uprouse937223uprouse
uprouses1037553uprouses
vrouws12494743_vrouws
wipeouts1354203wipeouts
workouts1544963workouts

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 Limit1340273436.82619634.8
3Display Results3433430.1103118.2
 (SQL Overall)1786913437.34224338.2
 
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.