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

176 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
grow8612730(None) 
brow97228441brow
crow96428131crow
frow106425051frow
glow85222521glow
grew85620261grew
grog65923341grog
grok95819681grok
grot55942051grot
growl96115821growl
grown95317351grown
grows95523921grows
prow97030381prow
row67453671_row
trow78031421trow
vrow105817471vrow
aglow94711972aglow
alow75328592alow
arrow83414882arrow
avow107816462avow
blow95827192blow
bow87051902_bow
braw94829562braw
brew95023562brew
bro56236602bro_
broo65129822broo
bros65635662bros
brown105619532brown
brows105425982brows
chow125820992chow
cow89856712_cow
craw97725262craw
crew96122672crew
croc85723732croc
crop87628632crop
crowd115815622crowd
crown105620082crown
crows105727312crows
dhow116614002dhow
dow76749972_dow
draw85623012draw
drew86221672drew
drop75324402drop
drown95515822drown
enow77819872enow
eros45238452eros
flow105924922flow
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
frown115415972frown
frows116623102frows
gaol56925412gaol
giro55828632giro_
giron66118992giron
giros65722652giros
glob76623392glob
glom75424382glom
glop76724632glop
glows95518032glows
gnaw86515742gnaw
go38748742g_o_
goa47343802g_oa
gob68950892g_ob
god57449792g_od
goo47754772g_oo
good66531802good
goof85436872goof
gook96429602gook
goon57236172goon
goop75829482goop
goos57644912goos
gor47848262g_or
gore55744962gore
gorm75529392gorm
gorp75625902gorp
gory86129662gory
gos47155132g_os
got49870442g_ot
gowd96519982g_owd
gowk125516472g_owk
gown85724072g_own
gox117137182g_ox
goy77844552g_oy
grab75427612grab
grad66829862grad
gram77034582gram
gran56335012gran
grat55651282grat
gray85329892gray
gree56641562gree
grey85624042grey
grid65829612grid
grig65424772grig
grim76929422grim
grin55733722grin
griot65328412griot
grip76127022grip
grit55247242grit
groan65618422groan
groat65531972groat
grody103412062grody
grogs76319412grogs
groin65521082groin
groks105716122groks
groom85317982groom
grope84821612grope
gross65421692gross
grosz154814092grosz
grots65025852grots
group85413922group
grout65330422grout
grove95219332grove
grower104614932grower
growls104711112growls
growly13499172growly
growth1377382growth
grub77220082grub
grue55825712grue
grum75625082grum
gyro85217882gyro_
gyron95314622gyron
gyros95616482gyros
how97252432_how
iron46728462iron
jow137639302_jow
know116115842know
low66051872_low
meow95117882meow
mow86650352_mow
now65950192_now
ow58950172__ow
plow95923232plow
pow87147282_pow
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prop85932812prop
pros65742782pros
prowl105615122prowl
prows106327012prows
raw67252252_raw
regrow10309882regrow
rob56754302_rob
roc520243252_roc
rod47953892_rod
roe36861082_roe
rom59855632_rom
rot37282952_rot
rows75941752_rows
scow96021422scow
serow86720442serow
show106229192show
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
strow88920572strow
throw118719732throw
tow610557362_tow
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trows88826182trows
troy77429682troy
upgrow1234272upgrow
vow96136312_vow
vrouw11507342vrouw
vrows116115262vrows
wow96643472_wow
yow96945292_yow

Search took 1 second 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 Filter178691298720.0762351197.4
2DLD Change Limit298721760.73640587.0
3Display Results1761760.0305866.7
 (SQL Overall)1786911760.842212222.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.