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

219 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
trows8882618(None) 
brows105425981brows
crows105727311crows
frows116623101frows
grows95523921grows
prows106327011prows
rows75941751_rows
strows96718271strows
throws129715231throws
tows78545551t_ows
trews86118891trews
trogs67022601trogs
trois57226091trois
trots56629941trots
trow78031421trow_
troys86418611troys
vrows116115261vrows
arrows92813482arrows
avows114910982avows
blows105423832blows
bows96242862_bows
braws106425192braws
brews105617072brews
broos75126412broos
bros65635662bro_s
brow97228442brow_
brown105619532brown
browns116415632browns
browse115713852browse
chows135618202chows
cows97046642_cows
craws105723122craws
crews105917492crews
crocs95722432crocs
crops96125232crops
cross75124502cross
crow96428132crow_
crowd115815622crowd
crowds124910762crowds
crown105620082crown
crowns115615112crowns
dhows125911222dhows
dows85941052_dows
draws95119372draws
drops85719502drops
dross65418092dross
drown95515822drown
drowns105612332drowns
drowse105010552drowse
drowsy13487902drowsy
enows85115492enows
eros45238452ero_s
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
outrows10311402outrows
plows105419902plows
pows95537662_pows
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
props95726882props
pros65742782pro_s
pross76529402pross
prow97030382prow_
prowl105615122prowl
prowls115511082prowls
raws75238212_raws
robs65837872_robs
rocs65533662_rocs
rods56442062_rods
roes45954132_roes
roms67038962_roms
rots46454092_rots
row67453672_row_
scows106617802scows
serows96016392serows
shows115324582shows
slows85323462slows
snows84719892snows
sows75342492_sows
stows86622702stows
straws98718672straws
strews96817092strews
strops86220382strops
strow88920572strow_
strown96812092strown
stroys95914602stroys
taos45541002tao_s
tarocs84615662tarocs
taroks106115282taroks
taros55640822taro_s
tarots66422992tarots
taws75641592t_aws
tews76431642t_ews
thaws116515462thaws
thews117416192thews
thous86017262thous
thraws129211102thraws
throbs118311372throbs
throes97518672throes
throw118719732throw_
thrown1214911442thrown
tiros54524892tiro_s
tods56141842t_ods
toes46956442t_oes
togs57242432t_ogs
toms68343492t_oms
tons46553052t_ons
tools55325242tools
toons55027532toons
toots55331872toots
tops66248122t_ops
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torous64319032torous
torrs53923562torrs
tors46157382t_ors
torts56138122torts
torus54329762torus
toss45637972t_oss
tots46654122t_ots
tow610557362t_ow_
town76928702t_own
towns86018882t_owns
towy105325472t_owy
toys78036342t_oys
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trawl84915872trawl
trawls94412392trawls
trays85623432trays
trees55835762trees
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
treys85018212treys
tries55742812tries
trigs65423062trigs
trims75021472trims
triols66117802triols
trios55528092trios
trips74923362trips
troak95213572troak
troaks104410602troaks
trock114817602trock
trocks123614632trocks
trod57627952tro_d
trode65322852trode
trog57628212tro_g
troke94821052troke
trokes104019262trokes
troll54416532troll
trolls64613942trolls
tromp95815802tromp
tromps104911702tromps
trona54118952trona
tronas63816902tronas
trone55131862trone
trones65629282trones
troop76417532troop
troops85712782troops
trooz145016152trooz
trop66833302tro_p
trope75725802trope
tropes84824352tropes
trot46351312tro_t
troth85622202troth
troths95414152troths
trout57332572trout
trouts66116632trouts
trove85221922trove
troves94719112troves
trowed104714652trowed
trowel94211462trowel
trowels10358362trowels
trowth1277882trowth
trowths1365022trowths
troy77429682tro_y
trues54925322trues
trugs65516802trugs
truss54916922truss
twos76718022two_s
tyros85118592tyro_s
vows106626942_vows
vrouws12494742vrouws
vrow105817472vrow_
wows104633492_wows
yows106433122_yows

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.0931921408.6
2DLD Change Limit538002191.39038705.0
3Display Results2192190.0633476.2
 (SQL Overall)1786912191.546115582.8
 
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.