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

364 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
coned8604005(None) 
boned85133241boned
caned85838091caned
cloned94518801cloned
coded95433181coded
coed77140541co_ed
coined94523601coined
coked124730691coked
coled85540751coled
cone67256961cone_
cones76457421cones
coney105932881coney
conked135019111conked
conned95119701conned
cooed84534341cooed
coped105036841coped
cored85044221cored
corned95224521corned
coted85033851coted
coved115027371coved
cowed115637841cowed
coxed154322811coxed
coyed114623801coyed
honed95332261honed
toned65435341toned
zoned154020261zoned
acned87520662acned
acorned10238262acorned
atoned75417542atoned
awned96615952awned
baned85436352baned
boded95124962boded
bond75334362bon_d
bonded104719952bonded
bone65949322bone_
boner75133082boner
bones76446532bones
boney105227312boney
bonged105719602bonged
bonked135517312bonked
booed85127272booed
bored85034302bored
bowed114533422bowed
boxed154318612boxed
caged95426362caged
caked126128622caked
cane66653112cane_
caner75334772caner
canes75350372canes
canid85526342canid
canned95022062canned
canoed94618952canoed
canted94825782canted
caped104931802caped
cared86050092cared
cased86032412cased
caved116227562caved
cawed116627062cawed
ceded96118552ceded
censed94016322censed
cered85227442cered
chined125620062chined
choked164914792choked
chored125321882chored
chowed154914642chowed
cine66242942cine_
cines75239682cines
cited84421952cited
clone75728162clone_
cloner84418092cloner
clones84526562clones
clonked14429562clonked
closed95317962closed
clowned13447722clowned
cloyed125111562cloyed
clued84917682clued
coaled95022702coaled
coated94927032coated
coaxed165612512coaxed
cocked155022562cocked
cod69660122co__d
codded114515302codded
code77347732code_
codec107120342codec
coden86128542coden
coder86134212coder
codes86247292codes
codex155817572codex
coeds85920162co_eds
cogged116416612cogged
cohead123811122cohead
coifed124113062coifed
coigned11418662coigned
coiled95123932coiled
coiner84323782coiner
coke107038382coke_
cokes115537192cokes
cold77338772co_ld
cole66956112cole_
colead94114642colead
coles76055062coles
combed135516542combed
come87547702come_
comedo11359602comedo
comedy14378232comedy
comer95832692comer
comes97246992comes
comet95946072comet
comped135919872comped
con510268022con__
concede12310092concede
conch124620072conch
condo85322592condo
coneys115218422coneys
confer114018682confer
conga85419872conga
congaed11399742congaed
conge85227592conge
congee96024462congee
congeed113212312congeed
conger95024272conger
conges94928172conges
congo85623132congo
coni65534802con_i
conic95329792conic
conies84338592conies
conin76232722conin
conk106531442con_k
conker124721552conker
conks115525702conks
conky145818742conky
conn66229132con_n
conner84423962conner
conns75024232conns
conoid9818882conoid
cons66057692con_s
conte76633202conte
contend103511892contend
contes84432912contes
conto76027172conto
conus76726532conus
convex18367742convex
convey144610222convey
cony96537832con_y
cooee74531022cooee
cooeed95917862cooeed
cooer74831012cooer
cooey105828222cooey
cooked135921362cooked
cooled95224582cooled
cooped114821602cooped
cope86847382cope_
copen94826432copen
coper95336092coper
copes97747102copes
copied114618562copied
copped135221252copped
cord76740922co_rd
corded105923352corded
core67263112core_
corer75538872corer
cores76361852cores
corked135020782corked
cornea84018922cornea
cornel84020052cornel
corner84625622corner
cornet84436732cornet
cornfed1337382cornfed
cosec96320182cosec
coses76949492coses
coset75748842coset
cosey106226712cosey
coshed124217542coshed
cosied94819882cosied
costed95623112costed
cote66648732cote_
cotes76347842cotes
coude85022632coude
could86517712could
counted103815802counted
couped115019312couped
cove95837072cove_
coven106925042coven
cover105430772cover
coves105539172coves
covet105638942covet
covey136121782covey
cower104531772cower
cowled125218382cowled
coxes145430862coxes
coyer105222842coyer
cozen165019702cozen
cozened19349182cozened
cozes166033242cozes
cozey196718542cozey
cozied184112152cozied
craned96121652craned
cred76530882c_red
creed85727392creed
cried84624282cried
crone75231332crone_
crones84729242crones
crooned103813342crooned
crowed124717292crowed
crowned133912422crowned
cubed105519702cubed
cued76329562c_ued
cured85932132cured
dined76431992dined
doled75430912doled
domed95423262domed
done55747912done_
donee66931012donee
donned85015742donned
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
downed115314782downed
dozed165619352dozed
droned84616862droned
fined94930502fined
foined105915012foined
fond86330952fon_d
fonded115717042fonded
foxed165115212foxed
gonad75216052gonad
gone55639042gone_
gonef95221292gonef
goner66025162goner
gonged97115912gonged
gored75227082gored
gowned114410132gowned
hoed87837982ho_ed
hoked135326992hoked
holed95634132holed
homed115425422homed
hone77549322hone_
honer85332092honer
hones88144492hones
honey115629912honey
honied104818392honied
honked144517912honked
hoped115628182hoped
horned105718702horned
hosed95830982hosed
icones84616382icones
inned64118422inned
ironed74916012ironed
joined144613072joined
joked175217912joked
jones125028182jones
jowed164724422jowed
joyed164811832joyed
konked104010582konked
lined64934642lined
loaned73816292loaned
lobed86022132lobed
lone45849132lone_
loner55431042loner
longed87121372longed
looed64626132looed
loped85128332loped
loved95021362loved
lowed95233902lowed
loxed135017052loxed
maned86634092maned
mined85333352mined
moaned94514172moaned
monad85519472monad
monde85723142monde
money104826842money
monied94319462monied
mooed85123982mooed
mooned94216642mooned
moped105424732moped
moved114218152moved
mowed113629012mowed
neoned7311482neoned
none45743172none_
nones55639132nones
nonet54540842nonet
nosed65524552nosed
noted65123842noted
ohed87825182_ohed
one37050912_one_
ones46146532_ones
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
owed86833872_owed
owned95113232owned
paned85437182paned
phoned124014552phoned
pined85935322pined
poked125425392poked
poled84934842poled
ponced114314812ponced
pond75530492pon_d
ponded105218772ponded
pone65747532pone_
pones74547042pones
ponged105619352ponged
ponied94920702ponied
pooed85226242pooed
pored85234512pored
posed85828412posed
poxed154817862poxed
robed85323732robed
roped84630802roped
rosed65930342rosed
roved95323552roved
rowed94034322rowed
saned65636272saned
sconced12359172sconced
scone74621832scone_
scones84521302scones
scoped115116652scoped
scored94621132scored
scorned10229952scorned
scowed124413822scowed
sned56026052_sned
soled65835172soled
sonde64622832sonde
sone46649982sone_
sones55444142sones
sored66141782sored
sorned74820042sorned
sowed94933862sowed
stoned75923142stoned
tined65434532tined
toed56137042to_ed
toked105626492toked
toled65934922toled
tone46953742tone_
toner55336242toner
tones56048662tones
toney86027412toney
tonged86518902tonged
toped85631312toped
toted64929482toted
towed95134582towed
toyed96019802toyed
tuned64622312tuned
tyned95915012tyned
vaned94622422vaned
vined95626152vined
voled95323722voled
voted93919142voted
vowed124424572vowed
waned95831782waned
wined94434182wined
wonned104012062wonned
wonted103213282wonted
wooed94419872wooed
wowed124023772wowed
yoked134821622yoked
yond86122312yon_d
yowed1253025182yowed
zone135231082zone_
zoner144520342zoner
zones145528042zones
zonked20429472zonked
zooned164011082zooned

Search took 5 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.186960704.3
2DLD Change Limit538003643.62614837.3
3Display Results3643640.3131162.9
 (SQL Overall)1786913644.12543319.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.