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

189 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
stow7732574(None) 
scow96021421scow
show106229191show
slow77729491slow
snow76324791snow
sow66554761s_ow
staw78627691staw
stew77525461stew
stoa45425911stoa
stob66724611stob
stop66532031stop
stot46347331stot
stowp105614231stowp
stows86622701stows
strow88920571strow
tow610557361_tow
alow75328592alow
atom67824522atom
atop66124752atop
avow107816462avow
bestow1149462bestow
blow95827192blow
bow87051902_bow
brow97228442brow
chow125820992chow
cow89856712_cow
crow96428132crow
dhow116614002dhow
dow76749972_dow
enow77819872enow
estop74312102estop
flow105924922flow
frow106425052frow
glow85222522glow
grow86127302grow
how97252432_how
jow137639302_jow
know116115842know
kotow12528712kotow
low66051872_low
meow95117882meow
mow86650352_mow
now65950192_now
ow58950172__ow
plow95923232plow
pow87147282_pow
prow97030382prow
row67453672_row
saw68255352s_aw
scop85925522scop
scot66242612scot
scowl1012012972scowl
scows106617802scows
serow86720442serow
seton55223542seton
sew66247262s_ew
shaw108132552shaw
shew108030762shew
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
shown115216482shown
shows115324582shows
showy145714012showy
skew116218762skew
slaw77930712slaw
slew76228232slew
slob66029422slob
sloe45534952sloe
slog56728272slog
slop66533872slop
slot46049832slot
slows85323462slows
smew95017732smew
smog76317412smog
snaw78923072snaw
snob65825592snob
snog55623632snog
snot44745452snot
snows84719892snows
snowy115011562snowy
so28855442s_o_
sob57857942s_ob
sod46053702s_od
sol37256622s_ol
som59153812s_om
son37761952s_on
sook84933392sook
soon46240502soon
soot45761062soot
sop57557862s_op
sos37761602s_os
sot310384302s_ot
soth75932522soth
sotol54917652sotol
sots45552452sots
sou37853692s_ou
sown75127452s_own
sows75342492s_ows
sox106444192s_ox
soy67851452s_oy
spew95421872spew
spot65540692spot
stab67329932stab
stag57332002stag
star48037762star
stat47352692stat
stay78333722stay
stem610628252stem
step67126292step
stet45947322stet
stews85519142stews
stewy116112062stewy
stey76224412stey
stir45723252stir
stoae55024262stoae
stoai55417872stoai
stoas55126022stoas
stoat57135952stoat
stobs75718232stobs
stock114417562stock
stogy95414082stogy
stoic7317252stoic
stoke94922512stoke
stole54928812stole
stoma75918272stoma
stomp95616662stomp
stone55431182stone
stony85818642stony
stood65517712stood
stook95218212stook
stool55619892stool
stoop75821542stoop
stope74727242stope
stops74827282stops
stopt76528352stopt
store56333812store
stork96819692stork
storm76520402storm
story86723032story
stoss54316342stoss
stots54828552stots
stott56929792stott
stoup75517072stoup
stour54916742stour
stout57434052stout
stove85220252stove
stowed105817202stowed
stowps115710582stowps
straw813321292straw
strew89220662strew
strop77422242strop
strown96812092strown
strows96718272strows
stroy87720392stroy
stub66221842stub
stud56220092stud
stum65526022stum
stun45623452stun
sty66227312st_y
stye76218972stye
swob95218632swob
swop95120502swop
swot75134662swot
taw610155452_taw
tew66640152_tew
to218858982_to_
tod49457072_tod
toe310166852_toe
tog410255042_tog
tom514358052_tom
ton310265102_ton
too38965422_too
top510560682_top
tor39261682_tor
tot38884772_tot
town76928702_town
tows78545552_tows
towy105325472_towy
toy69655192_toy
trow78031422trow
two67925832_two
vow96136312_vow
vrow105817472vrow
wow96643472_wow
yow96945292_yow

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 Filter178691298720.283631417.0
2DLD Change Limit298721890.84335435.3
3Display Results1891890.0306300.0
 (SQL Overall)1786911891.156154577.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.