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 “crows” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

213 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
crows10572731(None) 
brows105425981brows
chows135618201chows
cows97046641c_ows
craws105723121craws
crews105917501crews
crocs95722431crocs
crops96125231crops
cross75124501cross
crow96428131crow_
crowd115815621crowd
crowds124910761crowds
crown105620081crown
crowns115615111crowns
frows116623101frows
grows95523921grows
prows106327011prows
rows75941751_rows
trows88826181trows
vrows116115261vrows
across8312642across
arrows92813482arrows
avows114910982avows
blows105423832blows
bows96242862_bows
braws106425192braws
brews105617072brews
broos75126412broos
bros65635662bro_s
brow97228442brow_
brown105619532brown
browns116415632browns
browse115713852browse
cahows14399122cahows
carobs104818102carobs
carols85124982carols
caroms105619572caroms
caws96036112c_aws
ceros74726072cero_s
cerous85821202cerous
chaws135022462chaws
chews135418512chews
chops125019872chops
chow125820992chow_
chowse144711752chowse
cions75222852cions
claws106020832claws
clews105516332clews
clods85320862clods
clogs85519552clogs
clons75228132clons
clops95924852clops
clots75627642clots
clown105214732clown
clowns114810112clowns
cloys104916942cloys
cobs87043142c_obs
cods76848102c_ods
cogs77340032c_ogs
cols66553082c_ols
cons66057692c_ons
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492c_oos
coots75636842coots
cops86751372c_ops
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442c_ors
cos510270392c_o_s
coss66143492c_oss
cots68054842c_ots
cow89856712c_ow_
cowl97530812c_owl
cowls106922212c_owls
cowy126427362c_owy
coys97537242c_oys
crabs95421392crabs
crags85622572crags
crams96229152crams
craps95328642craps
crass76328042crass
craw97725262craw_
crawl104916712crawl
crawls114712082crawls
creds85418772creds
cress75022832cress
crew96122682crew_
cribs94516752cribs
cries75438402cries
cris66233432cr_is
crits75527572crits
croak115216632croak
croaks125812982croaks
croc85723732cro_c
croci95818132croci
crock135921992crock
crocks145118422crocks
crocus104813172crocus
croft105622682croft
crofts114910592crofts
crone75231332crone
crones84729242crones
crony105918672crony
crook115217572crook
crooks124914412crooks
croon75522782croon
croons85418422croons
crop87628632cro_p
crore74922872crore
crores86121162crores
crosse85216302crosse
croup95616782croup
croups104312552croups
crouse84619362crouse
crowdy15467172crowdy
crowed124717302crowed
crower114117562crower
crowers124614902crowers
croze164719452croze
crozes174417662crozes
cruds85815852cruds
cruors838642cruors
crus65828482cr_us
dhows125911222dhows
dows85941052_dows
draws95119372draws
drops85719502drops
dross65418092dross
drown95515822drown
drowns105612332drowns
drowse105010552drowse
drowsy13487902drowsy
enows85115492enows
eros45238452ero_s
escrows1235802escrows
flows115822362flows
froes86126692froes
frogs96220772frogs
frons86124042frons
frow106425052frow_
frown115415972frown
frowns126011392frowns
frowst125512072frowst
frowsy15498272frowsy
glows95518032glows
grogs76319412grogs
groks105716122groks
gross65421692gross
grots65025852grots
grow86127302grow_
growl96115822growl
growls104711112growls
grown95317352grown
hows106345602_hows
irons55324132irons
jows146632092_jows
knows124912412knows
lows75843012_lows
meows104612682meows
mows96340832_mows
nows75738232_nows
plows105419902plows
pows95537662_pows
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782pro_s
pross76529402pross
prow97030382prow_
prowl105615122prowl
prowls115511082prowls
raws75238212_raws
robs65837872_robs
rocs65533662_rocs
rods56442062_rods
roes45954142_roes
roms67038962_roms
rots46454092_rots
row67453672_row_
scows106617802scows
screws115513892screws
scrods94111612scrods
serows96016392serows
shows115324582shows
slows85323462slows
snows84719892snows
sows75342492_sows
stows86622702stows
strows96718272strows
throws129715232throws
tows78545552_tows
trews86118892trews
trogs67022602trogs
trois57226092trois
trots56629942trots
trow78031422trow_
troys86418612troys
vows106626942_vows
vrouws12494742vrouws
vrow105817472vrow_
wows104633492_wows
yows106433122_yows

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538002131.84329191.5
3Display Results2132130.0603550.0
 (SQL Overall)1786912132.21680636.7
 
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.