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

375 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
ochone1131129(None) 
achene11313812achene
chine105231722_chine
choke145118022_choke
chon96627792_chon_
chore105126762_chore
chose105925402_chose
clone75728162_clone
cohune1189422cohune
colone85425002colone
cone67256962_c_one
crone75231332_crone
hone77549322__hone
ochre103411592och_re
octane81411632octane
orgone71110912orgone
ozone14310612o_zone
phone105621932_phone
scone74621832sc_one
shone83725972_shone
acetone9310793acetone
ache96829823ach__e
achenes12313493achenes
aching126521973aching
achiote1239213achiote
achoo10315083acho_o
acne66625873ac__ne
acnode938193acnode
agone65924553_agone
alone55732963_alone
ancone83916953ancone
anyone94612733anyone
archine125817053archine
archon11311753archon_
archons12311583archons
ashore9414613ashore
atone56527983_atone
axone125918473_axone
begone9512133begone
behove14207203behove
bizone1738603bizone
boche124216953boch__e
bone65949323__bone
bygone1256173bygone
cane66653113_c_ane
canoe75627253_canoe
chafe135117353_chafe
chaine115119223_chaine
chalone12312103_chalone
chance134617093_chance
chang115418563_chang
change124116753_change
chant105932693_chant
chape125221143_chape
chare105231983_chare
chase105127123_chase
chide115321013_chide
chile105626893_chile
chime125322593_chime
chin96934743_chin_
china105022473_china
chined125620063_chined
chines115029173_chines
chink145321593_chink
chino105823313_chino
chinone12510153_chinone
chins105631463_chins
chive135117623_chive
choana1138443_choana
choanae1236863_choanae
chock164316613_chock
choice132010523_choice
choir105313593_choir
choked164914793_choked
choker154314373_choker
chokes154917383_chokes
chokey184811713_chokey
choky175711223_choky
chola104718033_chola
choler113717153_choler
choline122915383_choline
cholo105217973_cholo
chomp144815663_chomp
chook146015043_chook
choose115116143_choose
chop116024923_cho_p
chopine143512263_chopine
chops125019873_chops
chord115917263_chord
chorea115216083_chorea
chored125321883_chored
chores114828023_chores
chorine123218363_chorine
chosen116014133_chosen
choses115825123_choses
chott103923923_chott
chouse116017563_chouse
chow125820993_cho_w
chowed154914643_chowed
chows135618203_chows
chowse144711753_chowse
chrome133214813_chrome
chunk144812383_chunk
chute104316463_chute
chyle134913483_chyle
chyme156512503_chyme
cine66242943_c_ine
cion613330913_cion_
cions75222853_cions
cline76428533_cline
clon66232483_clon_
cloned94518803_cloned
cloner84418093_cloner
clones84526563_clones
clonk114417443_clonk
clons75228133_clons
close76425223_close
clove105619443_clove
cloze165517543_cloze
cocaine111315173cocaine
cochin131313203cochin_
cochins141413093cochins
cocoon10312263cocoon_
cocooned1337293cocooned
cocoons11310563cocoons
code77347733_c_ode
codon86522853codon_
codons96119463codons
cogon89120903cogon_
cogons96818113cogons
cohere112716993cohere
coho97524493coho__
cohog117813043coho_g
cohogs125810273cohogs
cohort1110720263cohort
cohos105921853coho_s
cohosh14517123cohosh
cohost115217213cohost
cohunes1249713cohunes
coigne94612193coigne
cojones163512103cojones
coke107038383_c_oke
cole66956113_c_ole
cologne1039353cologne
colon78630193colon_
colonel94213283colonel
colones96124433colones
coloni85619203coloni
colons86028683colons
colony115417273colony
come87547703_c_ome
comose105016843comose
compone136517193compone
con510268023_c_on_
condone102616293condone
coned86040053_c_oned
cones76457423_c_ones
coney105932883_c_oney
conge85227593_c_onge
coni65534803_c_oni
conine84528553conine
conk106531443_c_onk
conn66229133_c_onn
cons66057693_c_ons
conte76633203_c_onte
cony96537833_c_ony
cooee74531023_cooee
coon67248943_coon_
coons76737283_coons
cope86847383_c_ope
core67263113_c_ore
corona83817403corona
coronae94214893coronae
coronel94515223coronel
coroner94218203coroner
coronet94227173coronet
cosine83823513cosine
cote66648733_c_ote
cove95837073_c_ove
coyote11411783coyote
crane75331603_crane
crones84729243_crones
crony105918673_crony
crore74922863_crore
croze164719453_croze
cyclone1437243cyclone
debone93714783debone
depone93616553depone
dhole95215363_dhole
doggone1035683doggone
done55747913__done
drone65324983_drone
eche97520283ech__e
eching126315563eching
echini114710433echini
echo96615953echo__
echoed125211153echoed
echoer114011103echoer
echoes114715523echoes
echoey14397853echoey
echoic1339043echoic
echoing1358613echoing
echos105216463echo_s
ecotone938583ecotone
eocene8311613eoc_ene
ethane94613243ethane
ethene93312923ethene
ethyne12407153ethyne
evzone1894683evzone
fordone1149373fordone
forgone1139343forgone
foxhole2045073foxhole
geophone1447433geophone
gone55639043__gone
hexone16289233hexone
hoe67562723__ho_e
hoke115935933__hoke
hole77553393__hole
home98042443__home
hon67759383__hon_
honed95332263__honed
honer85332093__honer
hones88144493__hones
honey115629913__honey
hong85833953__hong
honk116931193__honk
hons77350783__hons
hope96639673__hope
hormone12410503hormone
hose76547243__hose
hove107132223__hove
howe106734103__howe
ichor1039473icho_r
ichors11310413ichors
icon66922043ic_on_
icones84616383ic_ones
icons76516493ic_ons
impone103011853impone
intone61115423intone
ionone6313443ionone
irone55126363_irone
isochore1355863isochore
isochrone1444313isochrone
jocose1537103joc_ose
ketone105014533ketone
krone94018733_krone
lactone9311393lactone
leone55018823_leone
lochan1139093lochan_
lochans1248833lochans
lone45849133__lone
machine14313493machine
mahoe10315573maho_e
none45743173__none
nonhome1248833nonhome
oblong935383oblong
oboe66822943o_bo_e
obole75917143o_bole
ocean71212963ocean_
oceans81211003oceans
ocher104516103och_er
ochered132610283ochered
ochers113915303ochers
ochery14319443ochery
ochrea11316643ochrea
ochreae12295083ochreae
ochred12328003ochred
ochres113510833ochres
ochring13156673ochring
ochroid1357903ochroid
ochrous1237933ochrous
ochry13346933och_ry
ocreae83310273ocreae
octan71313483octan_
octanes91111393octanes
octans81411143octans
octant81216553octant
octave11157343octave
octopi1036533octopi
odeon6411483odeon_
odeons739023odeons
ohing96018803o_hing
oho66534383o_ho__
oilhole1046263oilhole
oleine6313793oleine
one37050913___one
onion54320973onion_
onions64016433onions
oniony9369703oniony
online6315843online
onshore10310013onshore
oohing104412933oohing
oolong738073oolong
ooze136420603o__oze
ophite11410563ophite
opine77422463o_pine
oppose1039193oppose
orgones81010793orgones
oriole6814293oriole
orlon5415003orlon_
orlons6411013orlons
orpine83914483orpine
oscine8311563oscine
osmole8128513osmole
osmose8108003osmose
otiose639403otiose
ouching134314903ouching
outdone8311643outdone
outgone8311463outgone
outshone1149343outshone
ovine86316643o_vine
oxytone1744203oxytone
ozones1539393o_zones
phon95925383_phon_
phoned124014553_phoned
phones114121213_phones
phoney143612983_phoney
phono104917023_phono
phons105221143_phons
phony136715443_phony
poechore1547853poechore
pone65747533__pone
pothole12312173pothole
prone75332623_prone
pyrone112714473pyrone
rechose121312043rechose
redone74820053redone
reshone102414163reshone
rezone153814783rezone
scene77220573sc_ene
scheme1379633scheme
schmoe13328333schmoe
schnoz2035643schnoz
school11410723school
schooner1336623schooner
schorl1179803schorl
scion72214993scion_
scions82612233scions
sconce104711723sc_once
scones84521303sc_ones
scope94821483sc_ope
score75526733sc_ore
shine85533093_shine
shoe75933433_sho_e
shore85432643_shore
shote85526083_shote
shove114421033_shove
someone938813someone
sone46649983__sone
soochong14104373soochong
souchong1484513souchong
sphene113412403sphene
stone55431183_stone
thane86122533_thane
thine85026853_thine
thole85620843_thole
thong95014173_thong
those85218143_those
throne98517603throne
tone46953743__tone
torchon1237363torchon_
torchons1337503torchons
touchtone1443973touchtone
trone55131863_trone
unchoke16248193unchoke
undone7914253undone
uphove1436133uphove
vahine123612113vahine
wahine123813013wahine
whine116022813_whine
whole114418093_whole
whore116018043_whore
whose114914533_whose
zone135231083__zone
zoochore2245783zoochore

Search took 6 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.1401276364.3
2DLD Change Limit1127163755.15621861.1
3Display Results3753750.1402678.6
 (SQL Overall)1786913755.43632871.8
 
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.