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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
grown9531735(None) 
brown105619531brown
crown105620081crown
drown95515821drown
frown115415971frown
gown85724071g_own
groan65618421groan
groin65521081groin
grow86127301grow_
growl96115821growl
grows95523921grows
adown95611662adown
blown105716672blown
brawn106018562brawn
brow97228442brow_
browns116415632browns
browny144510042browny
brows105425982brows
clown105214732clown
croon75522782croon
crow96428132crow_
crowd115815622crowd
crowns115615112crowns
crows105727312crows
down86427492_down
drawn95614242drawn
drownd11478312drownd
drowns105612332drowns
flown116213992flown
frow106425052frow_
frowns126011392frowns
frows116623102frows
giron66118992giro_n
glow85222522glow_
glows95518032glows
gnawn9517782gnawn
godown1136032godown
goon57236172g_oon
gowan95415742g_owan
gowd96519982g_owd
gowk125516472g_owk
gowns95115102g_owns
grain65126252grain
gran56335012gr_an
green65522142green
grew85620262grew_
grin55733722gr_in
groans74815062groans
groat65531972groat
grody103412062grody
grog65923342gro_g
grogs76319412grogs
groins73917202groins
grok95819682gro_k
groks105716122groks
groom85317982groom
grope84821612grope
gross65421692gross
grosz154814092grosz
grot55942052gro_t
grots65025852grots
ground82310272ground
group85413922group
grout65330422grout
grove95219332grove
grower104614932grower
growing123512472growing
growls104711112growls
growly13499172growly
grownup1342212grownup
growth1377382growth
groyne1037212groyne
gyron95314622gyro_n
ingrown1145392ingrown
iron46728462iro_n
known12568342known
kroon94514482kroon
lown76929292_lown
mown95424442_mown
own66429702__own
prawn105312432prawn
prow97030382prow_
prowl105615122prowl
prows106327012prows
regrown11237362regrown
roan47234202_roan
row67453672_row_
rowan85418732_rowan
rowen84921152_rowen
rows75941752_rows
shown115216482shown
sown75127452_sown
strown96812092strown
thrown1214911442thrown
town76928702_town
trow78031422trow_
trows88826182trows
upgrown1343852upgrown
vrow105817472vrow_
vrows116115262vrows

Search took 2 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.300595636.7
2DLD Change Limit538001001.43637465.2
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.766101184.0
 
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.