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

178 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
dawts9721612(None) 
darts67635731darts
dauts67822241dauts
dawks135213491dawks
dawns95916591dawns
daws86638241daw_s
dawt85435941dawt_
acts66929862_acts
adapts9107812adapts
adits66523712adits
aits46355532_aits
alts46639902_alts
ants47243472_ants
arts49650262_arts
awes76037552_awes
awls75926092_awls
awns75324432_awns
bahts105617802bahts
baits76630582baits
basts75936932basts
bats66962332ba_ts
batts76727562batts
bawds116115492bawds
bawls105719322bawls
bawty135614102bawty
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342ca_ts
caws96036102caw_s
dabs77139402da_bs
daces85030682daces
dadas75819862dadas
dados75522432dados
dads67442772da_ds
daffs125116422daffs
daft85537252daft_
dagos76419442dagos
dags66642602da_gs
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372da_ms
dangs75623202dangs
dans56748152da_ns
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
dart55857872dart_
data56026652da_ta
date56443322da_te
dates65639152dates
dato56129942da_to
datos65222782datos
datto65416422datto
dattos74311902dattos
daubs85014562daubs
daunts75014082daunts
daut56443562daut_
davits104012362davits
daw77148362daw__
dawed106222812dawed
dawen95413722dawen
dawk126117282daw_k
dawn85624202daw_n
dawted11489682dawted
dawtie103011092dawtie
dawties113312702dawties
days87637132da_ys
dazes155024142dazes
debts86418372debts
deets65330242deets
delts65731792delts
dents65031802dents
dews86230602dew_s
diets66026642diets
dints67431312dints
dirts66824462dirts
dits56450522d_its
doats65224882doats
doits66223672doits
dolts65626312dolts
dots55647662d_ots
downs94918572downs
dows85941052dow_s
drafts105012532drafts
drats66628372drats
drawls105511392drawls
draws95119372draw_s
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
dusts65923562dusts
easts57530322easts
eats47054872ea_ts
facts107021892facts
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
fawns115914262fawns
gaits65726012gaits
gasts66628632gasts
gats56753442ga_ts
gawks136811632gawks
gawps115911012gawps
haets86525122haets
hafts116219462hafts
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252ha_ts
hawks155415702hawks
haws106439442haw_s
jaws145027292jaw_s
karts97630112karts
kats85944332ka_ts
lasts57731262lasts
lats45962702la_ts
lawns85215422lawns
laws76441682law_s
malts76331752malts
marts77442232marts
masts77035762masts
mats65460292ma_ts
matts76829182matts
mauts75927192mauts
maws96437142maw_s
newts86015282newts
nowts86915862nowts
oasts56529182oasts
oats46554212oa_ts
pacts95125802pacts
pants76536922pants
parts77743372parts
pasts75936502pasts
pats66460852pa_ts
pawls105617662pawls
pawns108818132pawns
paws96038182paw_s
qats135331342qa_ts
rafts87820632rafts
rants55935342rants
rats46260372ra_ts
raws75238212raw_s
salts55431882salts
saws75839482saw_s
swats85726862swats
tacts76524122tacts
tarts57242022tarts
tats46858132ta_ts
tauts56125512tauts
taws75641592taw_s
twats86616602twats
vasts86423772vasts
vats76841742va_ts
vaws105527322vaw_s
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
wawls115416472wawls
waws106834902waw_s
yawls114613602yawls
yawns114213272yawns
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 Limit538001781.73331044.4
3Display Results1781780.0503560.0
 (SQL Overall)1786911781.87695251.1
 
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.