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

202 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
stows8662270(None) 
scows106617801scows
shows115324581shows
slows85323461slows
snows84719891snows
sows75342491s_ows
stews85519141stews
stoas55126021stoas
stobs75718231stobs
stops74827281stops
stoss54316341stoss
stots54828551stots
stow77325741stow_
stowp105614231stowp
stowps115710581stowps
strows96718271strows
tows78545551_tows
atoms76817562atoms
avows114910982avows
bestows1248862bestows
blows105423832blows
bows96242862_bows
brows105425982brows
chows135618202chows
cows97046642_cows
crows105727312crows
dhows125911222dhows
dows85941052_dows
enows85115492enows
estops84011222estops
flows115822362flows
frows116623102frows
glows95518032glows
grows95523922grows
hows106345602_hows
jows146632092_jows
knows124912412knows
kotows13446522kotows
lows75843012_lows
meows104612682meows
mows96340832_mows
nows75738232_nows
plows105419902plows
pows95537662_pows
prows106327012prows
rows75941752_rows
saws75839482s_aws
scops95820192scops
scots74025912scots
scow96021422scow_
scowl1012012972scowl
scowls11549592scowls
serows96016392serows
setons64620172setons
setous64917372setous
sews75836022s_ews
shaws116226262shaws
shews115924712shews
shoes85429662shoes
shogs95319712shogs
shoos84226362shoos
shops104222902shops
shots84730852shots
show106229192show_
shown115216482shown
showy145714012showy
skews125413802skews
slaws85222712slaws
slews86220352slews
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slots54830532slots
slow77729492slow_
smews104612292smews
smogs85112162smogs
snaws86116362snaws
snobs74716152snobs
snogs66017492snogs
snots55225122snots
snow76324792snow_
snowy115011562snowy
sobs64941752s_obs
sods54940212s_ods
sols45448162s_ols
soms66239372s_oms
sons46049552s_ons
sooks94425452sooks
soots55536212soots
sops65244562s_ops
sos37761602s_o_s
soths86218632soths
sotols63714472sotols
sots45552452s_ots
sous46947212s_ous
sow66554762s_ow_
sown75127452s_own
soys75233932s_oys
spews105015922spews
spots74424112spots
stabs76221382stabs
stags66226742stags
stars55836572stars
stats55933362stats
staw78627692staw_
stays86022022stays
stems75219952stems
steps76619882steps
stets55423912stets
stew77525462stew_
stewy116112062stewy
sties55132982sties
stirs55921622stirs
stoa45425912sto_a
stoae55024262stoae
stoai55417872stoai
stoat57135952stoat
stoats65117482stoats
stob66724612sto_b
stock114417562stock
stocks124715632stocks
stogy95414082stogy
stoic7317252stoic
stoics8311112stoics
stoke94922512stoke
stokes104821792stokes
stole54928812stole
stoles63927672stoles
stoma75918272stoma
stomas84816322stomas
stomp95616662stomp
stomps105612832stomps
stone55431182stone
stones65130032stones
stony85818642stony
stood65517712stood
stook95218212stook
stooks105115372stooks
stool55619892stool
stools65117022stools
stoop75821542stoop
stoops85917892stoops
stop66532032sto_p
stope74727242stope
stopes84525892stopes
stopt76528352stopt
store56333812store
stores65533662stores
stork96819692stork
storks106115952storks
storm76520402storm
storms85814632storms
story86723032story
stot46347332sto_t
stott56929792stott
stotts64612862stotts
stoup75517072stoup
stoups85313272stoups
stour54916742stour
stours65015632stours
stout57434052stout
stouts65019002stouts
stove85220252stove
stoves93818922stoves
stowed105817202stowed
straws98718672straws
strews96817102strews
strops86220382strops
strow88920572strow_
strown96812092strown
stroys95914602stroys
stubs75016072stubs
studs64415872studs
stums75320082stums
stuns54719492stuns
styes86316522styes
swobs104910892swobs
swops105913972swops
swots85518432swots
taws75641592_taws
tews76431642_tews
tods56141842_tods
toes46956442_toes
togs57242432_togs
toms68343492_toms
tons46553052_tons
tops66248122_tops
tors46157382_tors
toss45637972_toss
tots46654122_tots
tow610557362_tow_
town76928702_town
towns86018882_towns
towy105325472_towy
toys78036342_toys
trows88826182trows
twos76718022_twos
vows106626942_vows
vrows116115262vrows
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.313570897.8
2DLD Change Limit538002021.51335558.5
3Display Results2022020.0633206.3
 (SQL Overall)1786912021.88994595.6
 
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.