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

234 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
dauts6782224(None) 
darts67635731darts
daubs85014561daubs
daunts75014081daunts
daut56443561daut_
dawts97216121dawts
mauts75927191mauts
tauts56125511tauts
abuts75417072abuts
acts66929862_acts
adapts9107812adapts
adits66523712adits
adults7299952adults
adust64117452adust
aits46355532_aits
alts46639902_alts
ants47243472_ants
arts49650262_arts
auks85525262_auks
aunts55227632_aunts
auto47432082_auto
autos56523322_autos
bahts105617802bahts
baits76630582baits
basts75936932basts
bats66962332ba_ts
batts76727562batts
bauds85821042bauds
beauts86015282beauts
bhuts105812952bhuts
bouts75131312bouts
bruts75922952bruts
buts67247692_buts
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342ca_ts
cauls75727772cauls
cuts65841152_cuts
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
datum8310632datum
datums936352datums
daub77423442dau_b
daube85015302daube
daubes94913702daubes
dauby115211222dauby
daunt65929082daunt
dauted84114932dauted
dautie72914702dautie
dauties83315762dauties
davits104012362davits
dawks135213492dawks
dawns95916592dawns
daws86638242da_ws
dawt85435942dawt_
days87637132da_ys
dazes155024142dazes
debts86418372debts
debuts93911752debuts
deets65330242deets
delts65731792delts
dents65031802dents
dhuti937542dhuti
dhutis1035942dhutis
diets66026642diets
dints67431312dints
dirts66824462dirts
dits56450522d_its
doats65224882doats
doits66223672doits
dolts65626312dolts
donuts7410582donuts
dots55647662d_ots
doubts968732doubts
doums85417642doums
drafts105012532drafts
drats66628372drats
drubs85913832drubs
drugs75214652drugs
drums85415872drums
duads76515342duads
duals65620082duals
dubs78432192d_ubs
ducts85319892ducts
duds65530142d_uds
dues56045502d_ues
duets65323882duets
dugs614832282d_ugs
duits65021882duits
duns55140432d_uns
dunts65828412dunts
duos56728132d_uos
dups75929512d_ups
dust57142532d_ust
dusts65923562dusts
duty85321452d_uty
easts57530322easts
eats47054872ea_ts
facts107021892facts
farts88336842farts
fasts86429682fasts
fats76252502fa_ts
faults94513552faults
fauns84516752fauns
gaits65726012gaits
gamuts958782gamuts
gasts66628632gasts
gats56753442ga_ts
gauds75717722gauds
gaults74112782gaults
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
ghauts10447782ghauts
gluts66120132gluts
gouts64826172gouts
guts56637252_guts
haets86525122haets
hafts116219462hafts
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252ha_ts
hauls86123732hauls
haunts95614392haunts
haut75949732haut_
haute89521612haute
huts76737442_huts
jauks165412462jauks
jaunts137511882jaunts
jaups144810532jaups
juts115930162_juts
karts97630112karts
kats85944332ka_ts
krauts10418512krauts
lasts57731262lasts
lats45962702la_ts
lauds65618482lauds
louts56330272louts
malts76331752malts
marts77442232marts
masts77035762masts
mats65460292ma_ts
matts76829182matts
mauds85519272mauds
mauls76524952mauls
maut65448452maut_
muts64839982_muts
nuts45032672_nuts
oasts56529182oasts
oats46554212oa_ts
outs45746962_outs
pacts95125802pacts
pants76536922pants
parts77743372parts
pasts75936502pasts
pats66460852pa_ts
phuts104613502phuts
pouts75530322pouts
puts65641752_puts
qats135331342qa_ts
rafts87820632rafts
rants55935342rants
rats46260372ra_ts
routs57133412routs
ruts44541492_ruts
salts55431882salts
sauls55128122sauls
saults65816172saults
saute55028082saute
sautes63924912sautes
scuts74522522scuts
shuts85622482shuts
sluts54523982sluts
smuts75415712smuts
tacts76524122tacts
tarts57242022tarts
tats46858132ta_ts
taunts65715662taunts
taus46342732tau_s
taut47048962taut_
touts54830392touts
tuts45838452_tuts
uts35534372__uts
vasts86423772vasts
vats76841742va_ts
vatus86114642vatus
vaults94511672vaults
vaunts95212622vaunts
vaus75928922vau_s
wafts116920552wafts
waits88333522waits
wants87932212wants
warts814840402warts
wasts87433672wasts
wats77555882wa_ts
watts86923092watts
wauks125515162wauks
wauls86120552wauls
yauds95013222yauds
yaups105910742yaups

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.343520965.0
2DLD Change Limit538002341.62333148.5
3Display Results2342340.0633714.3
 (SQL Overall)1786912342.02988068.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.