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

350 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
dopes8493504(None) 
copes97747101copes
does56554471do_es
doges75630161doges
doles67843751doles
domes85735561domes
dopas85019061dopas
dope76038891dope_
doped95326711doped
doper86128391doper
dopers95522481dopers
dopey116020351dopey
doses65938501doses
dotes65836691dotes
doves94728151doves
dozes155226301dozes
dupes86425931dupes
hopes105835641hopes
lopes76437341lopes
mopes95134981mopes
opes65942611_opes
popes95933811popes
ropes75940061ropes
topes76941761topes
adobes94411532adobes
adopts998082adopts
adores74420722adores
apes66047432_apes
bodes84935102bodes
boles75448602boles
bones76446532bones
bops86037982bop_s
bores76448252bores
boxes145625072boxes
capes95441922capes
cepes94424462cepes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
cope86847382cope_
coped105036852coped
copen94826432copen
copens106119962copens
coper95336092coper
copers104629842copers
copies104130312copies
cops86751372cop_s
copse95623932copse
copses104922482copses
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
daces85030682daces
dales66439742dales
dames85435852dames
daps77239162dap_s
dares66146702dares
dates65639152dates
dazes155024142dazes
deeps84921772deeps
dees56356632d_ees
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dholes104914792dholes
dices86434242dices
dies55653522d_ies
dikes105831332dikes
dimes85833042dimes
dines66449152dines
diodes83915782diodes
dips75536912dip_s
dites66339152dites
dives95832402dives
doats65224882doats
dobies94422092dobies
docks126022312docks
docs75631152do_cs
dodges96119082dodges
dodoes85716102dodoes
dodos75819392dodos
doe47361952do_e_
doer57734702do_er
doers65225712doers
doest65829522do_est
doffs125614332doffs
doge66233802doge_
dogey105719512dogey
dogeys115510662dogeys
dogies85022252dogies
dogs66440152do_gs
doits66223672doits
dojos135111792dojos
dole56550002dole_
doled75430912doled
dolls66126922dolls
dols56943052do_ls
dolts65626312dolts
dome77240732dome_
domed95423262domed
doms76239572do_ms
donas65926472donas
done55747912done_
donee66931012donee
donees74519492donees
dongs76525812dongs
dons56048702do_ns
dooms85321342dooms
doors65022132doors
dopa77220902dop_a
dopier93515922dopier
dopiest103315992dopiest
dopy106224152dop_y
dore56353302dore_
dories75232362dories
dorks105724442dorks
dorms85723842dorms
dorper94314572dorper
dorpers104113172dorpers
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dos48062312do__s
dose56442432dose_
dosed76626912dosed
doser66228562doser
dosers75723632dosers
doss56235042do_ss
dosses76126272dosses
dote55442882dote_
doted75227072doted
doter65428622doter
doters74423912doters
dots55647662do_ts
doums85417642doums
douse66329722douse
douses74928932douses
dove85131562dove_
doven94718552doven
dovens104413902dovens
dowed104632612dowed
dowel95618192dowel
dowels104813342dowels
dower95027702dower
dowers104523292dowers
downs94918572downs
dows85941052do_ws
dowse96020812dowse
dowses105718302dowses
doxies143917852doxies
doyen95014412doyen
doyens104810222doyens
doze145829082doze_
dozed165619352dozed
dozen155017472dozen
dozens164612462dozens
dozer158419272dozer
dozers164815422dozers
drapes95419652drapes
drees65628522drees
dries64733672dries
drones75023432drones
drops85719502drop_s
droves105116672droves
drupes94912652drupes
duces86327472duces
dudes75424372dudes
dues56045502d_ues
dukes105023472dukes
dunes65332172dunes
dupe76630602dupe_
duped95118322duped
duper85519002duper
dupers94615602dupers
dups75929512dup_s
dures65635922dures
dyes85331892d_yes
dykes135215572dykes
dynes95917582dynes
elopes85918162elopes
foes76543442fo_es
fops96532682fop_s
fores85847102fores
foxes156321092foxes
gapes86030822gapes
goes55644092go_es
gores65740372gores
goxes135018262goxes
gropes95220402gropes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938822homes
hones88144492hones
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopers114222972hopers
hops97942632hop_s
hoses85443182hoses
howes114730262howes
hypes135818672hypes
japes146322822japes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jupes145218552jupes
kopek1037812kopek
kopeks1134602kopeks
kophs145010932kophs
kopjes1935362kopjes
kops107031292kop_s
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lop_s
lores55045402lores
loses56742012loses
loupes84918052loupes
loves85332012loves
lowes85732462lowes
loxes125227472loxes
modes85537412modes
mokes114631032mokes
moles74747922moles
momes95134472momes
mope86838042mope_
moped105424732moped
mopeds11499662mopeds
moper94925922moper
mopers104220372mopers
mopey124821822mopey
mops85940132mop_s
mores76249642mores
motes75944002motes
moues75732842moues
moves106128422moves
myopes13419962myopes
napes74828462napes
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
nope65934192nope_
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oops65232672oop_s
oozes145418712oozes
ope56845242_ope_
oped76230152_oped
open66427002_open
opens76118552_opens
ops56641252_op_s
opts68124742_opts
opus66420592_opus
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pes57259782__pes
pipes96030142pipes
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pope85535612pope_
pops86340952pop_s
pores75849032pores
poses74642762poses
poxes145325722poxes
qophs19507812qophs
rapes75740722rapes
ripes75435772ripes
robes75133302robes
rodes614039082rodes
roes45954142ro_es
roles56747982roles
rope65542912rope_
roped84630812roped
roper75431912roper
ropers84325902ropers
ropey106021872ropey
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scopes104719592scopes
sipes76036952sipes
slopes84820452slopes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
stopes84525892stopes
supes75628302supes
tapes75838602tapes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
tope65946382tope_
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
tophes115218422tophes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
tores55352672tores
totes55139682totes
tropes84824352tropes
types105721062types
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wipes104827082wipes
woes76440662wo_es
wops96634152wop_s
yipes106017842yipes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

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.310576422.6
2DLD Change Limit538003501.44037361.1
3Display Results3503500.0933763.4
 (SQL Overall)1786913501.84396956.6
 
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.