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

151 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
dawns9591659(None) 
awns75324431_awns
damns84916921damns
dans56748141da_ns
darns66927891darns
dawks135213491dawks
dawn85624201dawn_
daws86638241daw_s
dawts97216121dawts
downs94918571downs
fawns115914261fawns
lawns85215421lawns
pawns108818131pawns
yawns114213271yawns
ains46158882_ains
awes76037552_awes
awls75926092_awls
awn68035912_awn_
awny105919302_awny
banns75321232banns
bans66555132ba_ns
barns76335142barns
bawds116115492bawds
bawls105719322bawls
brawns115614082brawns
cains75334302cains
cans65050842ca_ns
carns75937562carns
caws96036102caw_s
dabs77139402da_bs
daces85030682daces
dadas75819862dadas
dados75522432dados
dads67442772da_ds
daffs125116422daffs
dagos76419442dagos
dags66642592da_gs
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
damans94715982damans
dames85435852dames
damn75724322damn_
damps105220412damps
dams77444372da_ms
dan46859662da_n_
dang65131532da_ng
dangs75623202dangs
dank95828232da_nk
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darn56434622darn_
darts67635732darts
dates65639152dates
datos65222782datos
daubs85014562daubs
daunt65929082daunt
daunts75014082daunts
dauts67822242dauts
davens104612912davens
daw77148362daw__
dawed106222812dawed
dawen95413722dawen
dawing114819822dawing
dawk126117282daw_k
dawned113912092dawned
dawt85435942daw_t
days87637132da_ys
dazes155024142dazes
deans66131392deans
dens55945072d_ens
dewans105215142dewans
dews86230602dew_s
dins56652042d_ins
diwans105110372diwans
djins1368452djins
dons56048702d_ons
down86427492down_
downy125714552downy
dows85941052dow_s
drains73719402drains
drawls105511392drawls
drawn95614242drawn_
draws95119372draw_s
drowns105612332drowns
duns55140432d_uns
durns64819862durns
earns55927562earns
fans76247362fa_ns
fauns84516752fauns
fawn105321952fawn_
fawny144711712fawny
gains65729512gains
gawks136811632gawks
gawps115911012gawps
gowns95115102gowns
hawks155415702hawks
haws106439442haw_s
jawans1657842jawans
jaws145027292jaw_s
kains96125642kains
kaons95014852kaons
karns96624142karns
lawn75925632lawn_
lawny115912012lawny
laws76441682law_s
mains75635092mains
mans66354532ma_ns
mawn94424132mawn_
maws96437132maw_s
naans55815252naans
nans46139392na_ns
owns76819582_owns
pains75138282pains
pans65855722pa_ns
pawls105617662pawls
pawn94625302pawn_
paws96038182paw_s
prawns11509022prawns
rains55140232rains
rawins95617622rawins
raws75238212raw_s
sains55639972sains
sans45153352sa_ns
sawn75428162sawn_
saws75839482saw_s
spawns11577922spawns
swans84625012swans
tains54936322tains
tans46154812ta_ns
tarns56433952tarns
tawny114713652tawny
taws75641592taw_s
towns86018882towns
vans76236722va_ns
vaws105527322vaw_s
wains86930862wains
wans76452262wa_ns
warns87231002warns
wawls115416472wawls
waws106834902waw_s
yarns85621792yarns
yawls114613602yawls
yawn106219092yawn_
yawps13628792yawps
yaws105531212yaw_s

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.0931921408.6
2DLD Change Limit538001511.81329674.6
3Display Results1511510.0463282.6
 (SQL Overall)1786911511.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.