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

197 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
towers9442367(None) 
bowers115523701bowers
cowers114625531cowers
dowers104523291dowers
lowers94624921lowers
mowers113219401mowers
powers113822321powers
rowers94924571rowers
sowers94923441sowers
tawers94118601tawers
tokers104818891tokers
toners64128001toners
topers85025321topers
toters65026361toters
towels94314641towels
tower85729201tower_
towery124012091towery
toyers95516331toyers
vowers124317181vowers
atoners75013952atoners
avowers1336332avowers
blowers124313592blowers
boners84825432boners
borers85122682borers
bowels114315592bowels
bower107328182bower_
bowery146012112bowery
bowlers123715782bowlers
bowyers15438732bowyers
boxers155013482boxers
coders95426982coders
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
covers114627962covers
cower104531772cower_
crowers124614902crowers
doers65225712do_ers
dopers95522482dopers
dosers75723632dosers
doters74423912doters
dowels104813342dowels
dower95027702dower_
dowery134311662dowery
downers113912772downers
dowsers115013532dowsers
dozers164815422dozers
ewers86018822_ewers
flowers133413172flowers
fowlers133411202fowlers
foyers125413132foyers
glowers113412092glowers
goers65520252go_ers
gofers104711512gofers
gomers94116882gomers
goners74420172goners
growers113612722growers
hewers123715272hewers
hoers85724922ho_ers
homers114821982homers
honers94324972honers
hopers114222972hopers
hosers95223972hosers
hovers124320252hovers
howes114730262howe_s
howlers133312352howlers
jokers175511192jokers
jowars16369652jowars
knowers1436352knowers
kotowers1534312kotowers
loners64225812loners
lopers84424142lopers
losers65123582losers
lovers94223432lovers
lower85830412lower_
lowery124112712lowery
lowes85732462lowe_s
mopers104220372mopers
movers115117192movers
mower104523452mower_
noters64021002noters
omers76923192_omers
others93918002others
otters64021512otters
overs85224792_overs
owes75137102_owe_s
owners94210702_owners
oyers87620882_oyers
pawers114818782pawers
plowers123812242plowers
pokers124617922pokers
polers84225642polers
posers84223972posers
powders134111552powders
power105325952power_
powters124015662powters
rogers74517912rogers
ropers84325902ropers
rovers95423522rovers
rowels94515452rowels
rowens94515302rowens
rower85430492rower_
sawers94620162sawers
sewers94719722sewers
showers134612682showers
sobers85218862sobers
sowars94318012sowars
sowens93613152sowens
sower85229312sower_
stokers114515182stokers
stoners74817952stoners
stopers94217372stopers
storers75018682storers
stovers103713732stovers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932202taters
tawer85223442tawer_
taxers134015282taxers
thawers13428482thawers
throwers14106032throwers
tiers55526522t_iers
tigers75616512tigers
tilers63523502tilers
timers84420992timers
titers64526412titers
tochers123413092tochers
toeas55726422to_eas
toes46956442to_e_s
toilers74116262toilers
tokens104711562tokens
toker95924912toker_
tokes95234972toke_s
tolars64817942tolars
toles55147132tole_s
tollers73217462tollers
tomes76037382tome_s
toner55336242toner_
tones56048662tone_s
tongers84116012tongers
tonners73816402tonners
toolers74416502toolers
tooters73818772tooters
topees85519702topees
toper75231022toper_
topes76941762tope_s
toppers113914602toppers
torero6313202torero
toreros7311342toreros
tores55352672tore_s
torrs53923562to_rrs
tors46157382to__rs
tossers74713502tossers
totems86810762totems
toter55932132toter_
totes55139682tote_s
totters74618732totters
tourers73512742tourers
tours55325892to_urs
touters74018352touters
toward10311062toward
towards1138782towards
towed95134582towe_d
towel84920522towe_l
towered112911402towered
towhees13277792towhees
towies93521192towies
townees10269782townees
towns86018882tow_ns
tows78545552tow__s
toyer84521552toyer_
triers64321522triers
trovers103713322trovers
trowels10358362trowels
trowsers11428002trowsers
tubers85017032tubers
tuners64417342tuners
tuyers94612562tuyers
twerp10398412t_werp
twerps11345152t_werps
twiers95410162twiers
twofers1364052twofers
twyers12497412twyers
tyers86220052t_yers
vomers115614942vomers
voters95017442voters
vowels124410482vowels
vower115220792vower_
wooers93712442wooers
wowsers13488762wowsers
yowes114926372yowe_s
yowlers13328922yowlers
zoners155115992zoners

Search took 4 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 Filter178691825510.376475242.0
2DLD Change Limit825511972.62331472.0
3Display Results1971970.0633127.0
 (SQL Overall)1786911973.06258357.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.