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

194 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
towns8601888(None) 
downs94918571downs
gowns95115101gowns
owns76819581_owns
tons46553051to_ns
toons55027531toons
town76928701town_
towny116114491towny
tows78545551tow_s
awns75324432_awns
boons75031912boons
bowls106121432bowls
bows96242862bow_s
browns116415632browns
clowns114810112clowns
coins75834552coins
conns75024232conns
cons66057692co_ns
coons76737282coons
corns76034762corns
cowls106922212cowls
cows97046642cow_s
crowns115615112crowns
dawns95916592dawns
dons56048702do_ns
down86427492down_
downy125714552downy
dows85941052dow_s
drowns105612332drowns
eons46638712eo_ns
fawns115914262fawns
fohns117310782fohns
foins85523382foins
fons76943892fo_ns
fowls115518892fowls
frowns126011392frowns
goons65326772goons
gowans105512292gowans
gowds105814042gowds
gowks136011952gowks
gown85724072gown_
hons77350782ho_ns
horns86125332horns
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602how_s
ions46737852io_ns
johns15398712johns
joins125818412joins
jowls156214522jowls
jows146632092jow_s
knowns13426442knowns
koans95818622koans
lawns85215422lawns
loans56026462loans
loins56728422loins
loons55731722loons
lowes85732462lowes
lown76929292lown_
lows75843012low_s
moans74624372moans
mons68152262mo_ns
moons75331002moons
morns75527442morns
mown95424442mown_
mows96340832mow_s
noons54125282noons
nouns56717312nouns
nows75738232now_s
nowts86915862nowts
ons36148512_o_ns
owes75137102_owes
owls76022932_owls
own66429702_own_
pawns108818132pawns
pons65850602po_ns
poons75430972poons
porns75527342porns
pows95537662pow_s
roans54926442roans
rowans95715342rowans
rowens94515302rowens
rows75941752row_s
sons46049552so_ns
sorns55028422sorns
sowans94215892sowans
sowens93613152sowens
sown75127452sown_
sows75342492sow_s
stowps115710582stowps
stows86622702stow_s
tains54936322tains
tans46154822t_ans
tarns56433952tarns
tawny114713652tawny
taws75641592taw_s
teens56227482teens
tens45647412t_ens
terns55226872terns
tews76431642tew_s
thens85921832thens
thins85826332thins
thorns95314102thorns
tins45251302t_ins
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toils54527492toils
toits55327472toits
tokens104711562tokens
tokes95234972tokes
tolans64319272tolans
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tomans85419132tomans
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
ton310265102to_n_
tone46953742to_ne
tones56048662tones
tong56434352to_ng
tongs65928462tongs
tonne54921432tonne
tonnes65320852tonnes
tonus56324302tonus
tony75635152to_ny
tools55325242tools
toon47740632toon_
toots55331872toots
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122to_ps
toras55540372toras
torcs75123762torcs
tores55352672tores
torn46044252torn_
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torts56138122torts
torus54329762torus
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tours55325892tours
touts54830392touts
tow610557362tow__
towed95134582towed
towel84920522towel
towels94314642towels
tower85729202tower
towers94423672towers
towie85821872towie
towies93521192towies
towing103823192towing
townee92815212townee
townees10269782townees
townie93312302townie
townies103113622townies
townish13167932townish
towy105325472tow_y
toxins133314282toxins
toyons95512132toyons
toyos87519142toyos
toys78036342to_ys
trans54933042trans
trows88826182trow_s
tuns45138662t_uns
turns55623242turns
twas76824082t_was
twins85118982twins
twos76718022t_wos
uptowns12194342uptowns
vows106626942vow_s
wons74942042wo_ns
wows104633492wow_s
yawns114213272yawns
yowes114926372yowes
yowls115715432yowls
yows106433122yow_s
zoons144919692zoons

Search took 3 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.296603685.8
2DLD Change Limit538001941.75030742.9
3Display Results1941940.0633079.4
 (SQL Overall)1786911942.10984727.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.