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 “addict” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

232 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
addict1071120(None) 
addicts1176011addicts
adduct1087371adduct
abduct11108542abduct
addicted1345072addicted
adding93914962adding
adduce1076452adduce
adducts1174602adducts
adit56443652a_di_t
admit8319492admi_t
admixt1637332admixt
adrift10313112adrift
advect12309122advect
advice12107882advice
asdic83814092asdic_
asdics9439862asdics
audit62527882audi_t
caddice13327732caddice
edict84722282_edict
faddist12289642faddist
indict93115572indict
readdict1246152readdict
zaddick2442992zaddick
abdicate1348903abdicate
abduce1197193abduce
abducts1265313abducts
abject17137703abject
acidic113612133acidic_
acmic11312333acmic_
act59557843a___ct
adapt81218553a_dapt
add510132363add___
addax1435993add_ax
added84918433add_ed
addend9458453addend
adder75419593add_er
adders84315703adders
addible11236063addible
addicting1485073addicting
addiction13146013addiction
addictive1644563addictive
addle74318353add_le
addled94112523addled
addles84216603addles
addling10229833addling
addrest958633addrest
adds67622453add__s
adduced1274353adduced
adducent1284713adducent
adducer1184163adducer
adduces1185763adduces
adducted1343913adducted
adductor1243463adductor
adept81219643a_dept
adhibit1345343adhibit
adieu6417423a_dieu
adios65822863a_dios
adipic1137263adipic_
adits66523713a_dits
adjoint15108283adjoint
adjunct1753583adjunct
adjust1447183adjust
admire949933admire
admits9411413admits
admix1557733admi_x
adopt81219743a_dopt
adroit7518793adroit
adult63520653a_dult
adunc837433adunc_
adust64117453a_dust
advects13276013advects
advent102613753advent
advert103215783advert
advices13136933advices
advise10139223advise
adzing174110013adzing
aedile73716653aedile
aedine73218393aedine
affect1448903affect
afflict1547043afflict
afrit8323173afri_t
ageist7315383ageist
agist66325583a_gist
aiding84423613aiding
airt45757783a__irt
ait38093903a__i_t
alist56136783a_list
alit46155693a_li_t
alnico877943alnico
ambit94223713ambi_t
amice96122873a_mice
amici94217393a_mici
amidic114012873amidic_
amidst94913233amidst
amnic95516243amnic_
anodic92813133anodic_
anoint6423633anoint
antic75728863antic_
antick124814583antick
antics84621453antics
aorist64827873aorist
apomict1349053apomict
apricot111010183apricot
ardent73022613ardent
areic73219393areic_
arnica8310443arnica
aroint6328153aroint
artist64125543artist
aspect10612823aspect
aspic95114733aspic_
aspics104211563aspics
assist6314603assist
astrict9614793astrict
atilt54828473a_tilt
attic75618353attic_
attics84413283attics
audial7312993audial
audient8312303audient
audile73315303audile
auding83616933auding
audio62917103audi_o
audios72312283audios
audits72814113audits
aulic74420243aulic_
auric74521743auric_
aurist65027253aurist
autist64324943autist
await85524493awai_t
azoic162912063azoic_
baddest112611143baddest
baddie104114033baddi_e
baddies114017873baddies
bandit93821133bandi_t
bardic11312923bardic_
bodice11711423bodice
caddices14297853caddices
caddie104316453caddi_e
caddied123710563caddied
caddies113718383caddies
caddis104613383caddi_s
caddish143810133caddish
cadmic1338983cadmic_
dadaist9310103dadaist
daddies103414943daddies
daric85623123daric_
darics94314113darics
davit93424593davi_t
deduct10610793deduct
deice84320033_deice
deist64633593_deist
delict94320333delict
depict113514793depict
dice75841893__dice
dick116432383__dick
dicot85429093__dicot
dicta84915633__dicta
dicty115116293__dicty
didact10711203didact
didst74619613_didst
diet57357533__diet
dint56759053__dint
dipt77339323__dipt
dirt55550383__dirt
dit47071333__di_t
doit56347853_doi_t
drift95722843_drift
dript86923873_dript
duct75735463__duct
duit56241583_dui_t
eddied9248323eddied
eddies83313163eddies
edicts94911703_edicts
edit54934863_edi_t
educt85017103_educt
evict104417143_evict
faddier1237783faddier
faddiest1338113faddiest
faddish15359003faddish
faddism14356723faddism
faddists13235543faddists
gaddi85211633gaddi__
gadding113411453gadding
gaddis94211373gaddi_s
haddest122711993haddest
haddock1885583haddock
idiot6718863_idiot
indicts103210723indicts
induct93212743induct
iodic84816753iodic_
kaddish16317973kaddish
laddie83713173laddi_e
laddies93715053laddies
laddish12299723laddish
ludic82912803ludic_
maddest112311213maddest
madding123711993madding
maddish14289483maddish
maledict1346673maledict
medic104619653medic_
medick154010133medick
medico113711163medico
medics114115353medics
modica11310063modica
nonaddict1354143nonaddict
nudist73813323nudist
oddest81710863oddest
oddish11107653oddish
oddity1135243oddity
odic74920573_odic_
odist6421913_odist
paddies113715723paddies
padding123412513padding
paddock17104733paddock
pandect12310953pandect
pandit93820753pandi_t
predict12315323predict
pudic104614563pudic_
radding103715003radding
readdicts1343613readdicts
redact9419043redact
redipt94116743redipt
relict83623903relict
saddest92412383saddest
sadist74221353sadist
sodic84917493sodic_
strict84821043strict
verdict1339583verdict
waddie114013323waddi_e
waddied13358563waddied
waddies124214753waddies
wadding133711943wadding
zaddik2134243zaddi_k

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162325.75019602.8
3Display Results2322320.0932494.6
 (SQL Overall)1786912326.23328668.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.