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

274 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
dopants103843(None) 
dopant9316131dopant_
decants103514442decants
depaints1136642depaints
departs104310682departs
doats65224882do_a_ts
docents102810802docents
dopas85019062dopa__s
dopings11408782dopings
odorants946042odorants
pants76536922__pants
sonants7511232sonants
adamants1186343adamants
adopts998083adop__ts
alants67722023_alants
ants47243473___ants
arpents93613083arpents
bepaints1235113bepaints
bezants1877343bezants
boarts84716873bo_arts
boasts85017923bo_asts
boats75635153bo_a_ts
bogans95714813bogan_s
bogarts1047743bogarts
boranes93720403boranes
brants85723053_brants
byzants2153223byzants
cants77036943__cants
chants115020393_chants
coacts105314333co_acts
coapts104614013co_apts
coasts85719143co_asts
coats75635003co_a_ts
cobalts1139203cobalts
compacts16368903compacts
comparts144210833comparts
coolants1039943coolants
copalms13367543copalms
copals105018943copa_ls
coparents1347973coparents
copays134911273copa_ys
copens106119963copen_s
copings124111843copings
coplots11511593coplots
copouts11311083copouts
coranto9311893coranto
corantos10310103corantos
cotans81317923cotan_s
counts84618273co_unts
courants10310803courants
cowpats1437713cowpa_ts
damans94715983daman_s
dangs75623203d__angs
dans56748153d__an_s
daphnes13327683daphnes
darts67635733d__arts
daunts75014083d_aunts
dauts67822243d__auts
dawts97216123d__awts
deans66131393d_ean_s
decanes103118913decanes
decant93524223decant_
dedans85915073dedan_s
defangs1235363defangs
defats105114553defa_ts
demands114311413demands
demasts1089223demasts
dements103016623dements
dents65031803d__ents
deodands1144603deodands
depaint10314593depaint_
depart94720563depart_
depends11348993depends
depicts12358463depicts
deplanes11311213deplanes
depones103717093depones
deports105012883deports
depots94716343dep_ots
derats74625063dera_ts
desalts839573desalts
desands94810163desands
descants112910143descants
detents83615153detents
deviants1236733deviants
dewans105215143dewan_s
dicasts1078703dicasts
didacts1186063didacts
dints67431313d__ints
dioxanes1645373dioxanes
dioxans1555313dioxan_s
diplonts1146473diplonts
dipnets10109033dipnets
discants112912023discants
disparts11109953disparts
displants1248073displants
divans104612393divan_s
diwans105110373diwan_s
doat56947673do_a_t_
docent92918683docent_
dockets144412243dockets
dogbanes1245433dogbanes
dogcarts1243883dogcarts
dognaps1134393dognaps
dogvanes1344303dogvanes
doings84913183do_ings
doits66223673do__its
dolmans10479683dolman_s
dolts65626313do__lts
domaines11611063domaines
domains10510873domains
dominants1245953dominants
domines102918973domines
dominos103210193dominos
donas65926473do__nas
donate73619503dona_te
donates83217223donates
dongs76525813do__ngs
donnas75511323do_nnas
dons56048703do__n_s
donuts7410583do_nuts
dopa77220903dopa___
dopamines1446043dopamines
dopers95522483dop_ers
dopes84935043dop__es
dopiest103315993dopiest
dopiness11289973dopiness
doping103919463dopin_g
dorados938203dorados
dormant102814373dormant_
dosages92310803dosages
dotages92311793dotages
dotards937253dotards
dots55647663do___ts
doubts968733do_ubts
dovens104413903doven_s
downs94918573do_wn_s
doyens104810223doyen_s
dozens164612463dozen_s
dozenth2044323dozenth
dozenths2142793dozenths
drafts105012533d_rafts
drats66628373d_ra_ts
droplets1136063droplets
dropouts1145003dropouts
ducats95011763duca_ts
dunts65828413d__unts
dynasts1155103dynasts
eluants737583eluants
epacts105010393_epacts
errants7410643errants
expands17195733expands
expats1537683expa_ts
explants1737023explants
foments122912053foments
fondants1246203fondants
fonts86124753fo__nts
forints10411833forints
formants13269953formants
founts94313383fo_unts
gelants82611443gelants
giants74713503_giants
goats65527303go_a_ts
gobangs11385833gobangs
gobans94412043goban_s
gowans105512293gowan_s
grants73722473_grants
hants86335403__hants
hogans105914313hogan_s
honans94814503honan_s
impacts13266503impacts
impaints1236243impaints
imparts11298533imparts
implants1237883implants
incants92012803incants
infants102210773infants
japans1539823japan_s
joints133811453jo_ints
jurants14379213jurants
koans95818623ko_an_s
korats105416063kora_ts
levants1037723levants
loans56026463lo_an_s
logans76319063logan_s
loments93413473loments
lorans65117603loran_s
lovats939073lova_ts
moans74624373mo_an_s
moats75827643mo_a_ts
moments113113123moments
moppets13307163moppets
mordants1137143mordants
mounts84115073mo_unts
mutants938583mutants
nonarts7311303nonarts
nonpasts1046553nonpasts
nopales93812523nopales
nopals84914023nopa_ls
oasts56529183_o_asts
oats46554213_o_a_ts
octants9128733octants
odorant8411393odorant_
opahs105411983_opa_hs
opals75718353_opa_ls
opens76118553_open_s
operants1039483_operants
opines84820703_opines
opts68124743_op__ts
orangs74116033_orangs
pacts95125803__pacts
paints85921833__paints
panes76148693__panes
pangs84628663__pangs
pans65855733__pan_s
pant66061263__pant_
panto76129413__panto
pantos85222743__pantos
panty105929303__panty
parts77743373__parts
pasts75936503__pasts
pats66460853__pa_ts
pedants10310113pedants
pints75936223__pints
plants84921803_plants
points85618533po_ints
pompanos1445243pompanos
poppets10338853poppets
propanes122415823propanes
punts75828003__punts
quants153614143_quants
rants55935343__rants
recants93217093recants
repaints1038483repaints
repasts93611933repasts
repents93717623repents
replants102811243replants
roans54926443ro_an_s
roasts64915413ro_asts
robands10219863robands
rodents8611543rodents
romanos94311483romanos
romans84620243roman_s
romaunts1043693romaunts
rowans95715343rowan_s
savants1038653savants
scants85219723_scants
secants93413893secants
slants64819083_slants
solands84412343solands
solanos74412853solanos
solans64122493solan_s
somans84619303soman_s
sonant6621953sonant_
sopranos1046433sopranos
sowans94215893sowan_s
spaits85017473_spaits
spanks124514123_spanks
spans74528733_span_s
spats75031383_spa_ts
tenants7311013tenants
teopans939203teopan_s
toasts65914993to_asts
tolanes74216313tolanes
tolans64319273tolan_s
tomans85419133toman_s
topazes1857313topazes
topknots1443303topknots
topmasts1244973topmasts
truants738163truants
tyrants1037453tyrants
volant9316323volant_
volante1038513volante
wants87932213__wants
womans114613653woman_s
wonts87621543wo__nts

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340272747.26618445.8
3Display Results2742740.0932946.2
 (SQL Overall)1786912747.78222962.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.