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

218 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
dopa7722090(None) 
dona55529631dona
dopas85019061dopas
dope76038891dope
dopy106224151dopy
adopt81219742adopt
boa56954032bo_a
bola66035562bola
bop77549482bop_
bops86037982bops
bora66141632bora
bota66236502bota
coca88030642coca
coda77029352coda
cola66541392cola
coma87134852coma
cop711162372cop_
copal95621782copal
copay126516312copay
cope86847382cope
copra98115462copra
cops86751372cops
copy116229802copy
coxa136922962coxa
dada66422452dada
dap66652452dap_
daps77239162daps
data56026652data
deva85720982deva
dip67848992dip_
dips75536922dips
dipt77339332dipt
dita56032532dita
diva85920892diva
do310155262do__
doat56947672doat
dobla84913642dobla
dobra85013102dobra
doby106022162doby
doc66841512do_c
dock116228742dock
docs75631152docs
dodo66024922dodo
doe47361952do_e
doer57734702doer
does56554472does
doff116225782doff
dog57449752do_g
doge66233802doge
dogma96112462dogma
dogs66440152dogs
dogy96126492dogy
doit56347852doit
dojo126016142dojo
dol47150652do_l
dole56550002dole
doll56632492doll
dolma86214172dolma
dols56943052dols
dolt56649422dolt
dom69752442do_m
domal85619202domal
dome77240732dome
doms76239572doms
don46757652do_n
donas65926472donas
done55747912done
dong66031652dong
donga76718422donga
donna66215032donna
dons56048702dons
doom76430072doom
door56928512door
dopant9316132dopant
doped95326712doped
doper86128392doper
dopes84935042dopes
dopey116020352dopey
dor47253922do_r
dore56353302dore
dork96531462dork
dorm76834632dorm
dorp76028052dorp
dorps85419222dorps
dorr56627722dorr
dors56747602dors
dorsa64617282dorsa
dory85836232dory
dos48062312do_s
dose56442432dose
doss56235042doss
dost57248352dost
dot47573182do_t
dotal64919622dotal
dote55442882dote
doth86225712doth
dots55647662dots
doty86128222doty
doula65717772doula
doum76226672doum
douma85817702douma
dour56330432dour
doura66518662doura
doux125817982doux
dove85131562dove
dow76749972do_w
down86427492down
dows85941052dows
doxy156419952doxy
doze145829082doze
dozy175920322dozy
drop75324402drop_
drops85719502drops
dropt86924432dropt
duma75524452duma
dup67637882dup_
dupe76630602dupe
dups75929512dups
dura55232112dura
fop86743702fop_
fops96532682fops
fora75937392fora
goa47343802go_a
hop87554592hop_
hope96639672hope
hops97942632hops
hora76136562hora
hoya107418372hoya
iota45127832iota
jota116423622jota
kapa106021302kapa
koa76737782ko_a
kola85124972kola
kop97440212kop_
koph135816552koph
koppa13397292koppa
kops107031302kops
kora86431562kora
lipa68425932lipa
loca65527682loca
lop58255312lop_
lope65941922lope
lops66043352lops
lota47233502lota
moa57249182mo_a
mola66035632mola
mop76950822mop_
mope86838042mope
mops85940132mops
mopy115721972mopy
mora66641272mora
moxa136917742moxa
napa66927262napa
nipa69421642nipa
noma67529462noma
nona46929062nona
nopal75517102nopal
nope65934192nope
nota46830772nota
nova76518952nova
oba57531552_oba
oca56731732_oca
oda48133052_oda
odea56224572odea
oka76926802_oka
oops65232672oops
op45850162_op_
opah96218402_opah
opal66923522_opal
ope56845242_ope
ops56641252_ops
opt57545542_opt
ora37250832_ora
ova66823792_ova
pa410456482__pa
papa85827142papa
pop76252252pop_
pope85535612pope
poppa8409892poppa
pops86340952pops
pupa85422812pupa
qoph185911942qoph
rope65542912rope
ropy96323412ropy
rota45834342rota
soap65831132soap
soba64927922soba
soca66330052soca
soda56329392soda
sofa75625602sofa
soja115619512soja
sola45541862sola
soma65635292soma
sop57557862sop_
soph97024202soph
sops65244562sops
sora45746912sora
soya75724432soya
spa55730812_spa
tapa65129152tapa
tepa66021682tepa
toea46732332toea
toga57027412toga
tola45236332tola
top510560682top_
topaz16315322topaz
tope65946382tope
toph96326872toph
topi67830392topi
topo66932402topo
tops66248122tops
tora47545992tora
wop87145132wop_
wops96634152wops
yoga87418052yoga
zoa128529992zo_a
zoea137118422zoea
zona136321962zona

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 Filter178691298721.186150666.9
2DLD Change Limit298722181.65618038.6
3Display Results2182180.0633460.3
 (SQL Overall)1786912182.90561511.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.