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

224 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
orchid128957(None) 
orchids1377211orchids
orchil1158651orchil
orchis11710771orchis
arched125717322arched
archil11611572archil
chid106626402__chid
orcein838182orcein
orchard1346932orchard
orchils1277702orchils
orcin72716572orc_in
orphic1368322orphic
ouched124316932ouched
outchid1338722outchid
torched133511352torched
urchin1138742urchin
ached119227833_ached
acid77533393_ac_id
acrid86920103_acrid
alcid85817963alc_id
aphid115515393_aphid
arachnid1455593arachnid
aramid93315603aramid
arced88224163arc_ed
arch98628443arch__
archaic1438823archaic
archer115016243archer
arches114822043arches
archils12510533archils
archine125817053archine
arching136216693arching
archive154610483archive
archived17355993archived
archly1437353archly
archon11311753archon
arcked136211943arcked
arctic10313513arctic
arid57642713ar__id
aroid65428333ar_oid
arshin9312173arshin
bached145519893bached
birched15349913birched
botched153611903botched
boychik2143943boychik
brachia141910423brachia
braid85822263br_aid
bromid112612893bromid
cached145419203cached
caid77837533__caid
chad105525503__chad
chi86228653__chi_
chia96026623__chia
chic115925203__chic
chide115321013__chide
child114516223__child
chin96934743__chin
chip116726423__chip
chis95933313__chis
chit96937463__chit
cichlid1545313cichlid
coached153313843coached
coccid102910743coccid
coccoid11299283coccoid
cochin131313203cochin
conchie143312683conchie
conchoid1688043conchoid
coracoid1348143coracoid
cormoid12310403cormoid
corvid12310473cor_vid
couched154115793couched
cricoid1239243cricoid
douched144012113douched
droid74218533dr_oid
druid74111323dr_uid
eched116919223_eched
ericoid1049893ericoid
etched123613703etched
forbid123312433for_bid
forced126316523forc_ed
fordid113512053for_did
foredid1238503foredid
frigid1136923frigid
fucoid1237893fucoid
glochid1445263glochid
godchild1642273godchild
gravid113710973gravid
grid65829613gr__id
hid76248363___hid
hoochie1537793hoochie
horrid10311553hor_rid
hotched163610923hotched
inched124514483inched
irid55927173ir__id
ischia1136393ischia
itched123812023itched
leched123716003leched
lichi104412953lichi_
lichis115212593lichis
lochia1158313lochia
lucid84314573luc_id
lurched13358033lurched
marched153813403marched
miched143913393miched
monorchid1746163monorchid
mooched153910533mooched
morbid112511463mor_bid
morphed1537133morphed
morphia1447473morphia
morphic1648693morphic
morphin1439003morphin
mouched153612593mouched
mucid104115253muc_id
mucoid1139773mucoid
niched125514063niched
notched134210303notched
ocher104516103o_cher
ochre103411593o_chre
ochred12328003o_chred
ochroid1357903o_chroid
ochry13346933o_chry
octad81510653o_ctad
ohed87825183o__hed
ohia75719363o__hia
oohed94214213o_ohed
ootid61416693o_otid
opioid9310083opioid
orach105219233orach__
orache114013593orach_e
oraches124216473oraches
orad56031693or__ad
orated74221503orated
orbed85516193or_bed
orbit73622063or_bit
orc57034923orc___
orca65522773orc__a
orcas75918623orc_as
orceins937743orceins
orchards1445913orchards
orchises1338773orchises
orchitic1546293orchitic
orchitis1346423orchitis
orcins83313433orcins
orcs67025433orc__s
ordain7810403ordain
oread64619603or_ead
orectic1138823orectic
oreide7311673or_eide
orgic8311823or_gic
oribi7311093oribi_
oribis838833oribis
origin7311033origin
ornis54616773or_nis
oroide7311703or_oide
orphan1137733orphan
orphism1446183orphism
orpin73415533or_pin
orris54516553or_ris
ortho8312293orth_o
ouch95724633ouch__
ouches114322183ouches
ouching134314903ouching
outbid91411853outbid
outchide1447213outchide
outdid81210913outdid
outhit92818463outhit
ovoid94811023o_void
oxid12815483o__xid
ozalid1696673ozalid
parched154013693parched
peched144915343peched
perched154713233perched
percoid12312313percoid
poached154212403poached
pooched152810083pooched
porch125918623porch__
porches143815673porches
pouched153612773pouched
prebid113512843prebid
rabid84520783_rabid
rachis114017653rachis
raid55243073_r_aid
ranid66429333_ranid
rapid86422033_rapid
rebid85121363_rebid
redid74922393_redid
resid64124093_resid
rid46754623_r__id
rigid7913893_rigid
roached133211833roached
rochet115423003rochet
rocked135022323rocked
roshi8310753roshi_
roshis9311793roshis
ruched124314633ruched
sarcoid10310453sarcoid
scorched16187193scorched
sordid83411153sor_did
syrphid1646103syrphid
teched124014433teched
techie11511723techie
torch107420933torch__
torches123715433torches
torchier1337463torchier
torching142510083torching
torchon1237363torchon
torchy14549533torch_y
toroid7416013tor_oid
torpid9310913tor_pid
torrid7311853tor_rid
touched134914963touched
tracheid1437583tracheid
trepid9310083trepid
trichoid1457813trichoid
trifid1039063trifid
trochil1258713trochil
trochoid1468443trochoid
unchic1338643unchic
urchins1238863urchins
ursid6311483ur_sid
vouched163910563vouched
whid115418873__whid
worship1547833worship
worthed1437873worthed
zechin20137703zechin

Search took 9 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 Limit1127162247.94014196.0
3Display Results2242240.1401600.0
 (SQL Overall)1786912248.22021738.6
 
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.