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

188 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
downs9491857(None) 
dawns95916591dawns
dons56048701do_ns
down86427491down_
downy125714551downy
dows85941051dow_s
drowns105612331drowns
gowns95115101gowns
owns76819581_owns
towns86018881towns
adorns74212612adorns
adown95611662adown_
awns75324432_awns
boons75031912boons
bowls106121432bowls
bows96242862bow_s
browns116415632browns
clowns114810112clowns
coins75834552coins
conns75024232conns
cons66057692co_ns
coons76737282coons
corns76034762corns
cowls106922212cowls
cows97046642cow_s
crowns115615112crowns
damns84916922damns
dans56748152d_ans
darns66927892darns
dawks135213492dawks
dawn85624202dawn_
daws86638242daw_s
dawts97216122dawts
deans66131392deans
dens55945072d_ens
dewans105215142dewans
dews86230602dew_s
dhows125911222dhow_s
dins56652042d_ins
disowns1136732disowns
diwans105110372diwans
djins1368452djins
doats65224882doats
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doffs125614332doffs
doges75630162doges
dogs66440152do_gs
doing74923582doing
doings84913182doings
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dols56943052do_ls
dolts65626312dolts
domes85735562domes
doms76239572do_ms
don46757652do_n_
dona55529632do_na
donas65926472donas
done55747912do_ne
dong66031652do_ng
dongs76525812dongs
donna66215032donna
donnas75511322donnas
donne65520462donne
donsy96414682do_nsy
dooms85321342dooms
doors65022132doors
dopas85019062dopas
dopes84935042dopes
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dos48062312do__s
doses65938502doses
doss56235042do_ss
dotes65836692dotes
dots55647662do_ts
doums85417642doums
dovens104413902dovens
doves94728152doves
dow76749972dow__
dowdy136112542dowdy
dowed104632612dowed
dowel95618192dowel
dowels104813342dowels
dower95027702dower
dowers104523292dowers
dowie94721142dowie
dowing114221512dowing
downed115314782downed
downer104414922downer
downers113912772downers
dowry126312482dowry
dowse96020812dowse
dowses105718302dowses
doyens104810222doyens
dozens164612462dozens
dozes155226302dozes
drown95515822drown_
drownd11478312drownd
drownds12346152drownds
duns55140432d_uns
durns64819872durns
eons46638712eo_ns
fawns115914262fawns
fohns117310782fohns
foins85523382foins
fons76943892fo_ns
fowls115518892fowls
frowns126011392frowns
godowns1234672godowns
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
tons46553052to_ns
toons55027532toons
town76928702town_
towny116114492towny
tows78545552tow_s
udons65411462udo_ns
vows106626942vow_s
wons74942042wo_ns
wows104633492wow_s
yawns114213272yawns
yowes114926372yowes
yowls115715432yowls
yows106433122yow_s
zoons144919692zoons

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 Limit538001881.37639098.8
3Display Results1881880.0603133.3
 (SQL Overall)1786911881.749102167.5
 
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.