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

247 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
orc5703492(None) 
arc510250901arc
or27354731or_
ora37250831ora
orb55736861orb
orca65522771orca
orcs67025431orcs
ore36661831ore
ors35750111ors
ort39465231ort
roc520243251roc
torc66333351torc
ar211379382ar_
arb510448422arb
arch98628442arch
arco68331542arco
arcs67834782arcs
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
bora66141632bora
bore66051332bore
boric98024222boric
bork106933822bork
born67338412born
bort65960962bort
bra56339462bra
bro56236602bro
brr56921922brr
cor59960942cor_
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735382corm
corn69945812corn
cors66656442cors
cory96941512cory
croc85723732croc
cru57129562cru
cry89726242cry
doc66841512doc
dor47253922dor_
dore56353302dore
dork96531462dork
dorm76834632dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
dry76526032dry
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738362ern
err35626532err
ers36046282ers
for66952072for_
fora75937392fora
forb97131332forb
force105324272force
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
fro65530642fro
fry96226502fry
gor47848262gor_
gore55744962gore
gorm75529392gorm
gorp75625902gorp
gory86129662gory
hic86540562hic
hora76136562hora
horn76735612horn
ire36943172ire
irk76426362irk
kor76538892kor_
kora86431552kora
kore85834162kore
kors85933012kors
lac510155822lac
lord55032082lord
lore45850352lore
lorn46435252lorn
lory75931712lory
mac78053932mac
marc87034632marc
merc87225622merc
mic77647642mic
moc77845082moc
mor56855002mor_
mora66641272mora
more67154522more
morn66237562morn
mors65950062mors
mort66758832mort
myc106519502myc
narc67127952narc
nor38048822nor_
nori47133142nori
norm66429812norm
oaf65952882oaf
oak76238652oak
oar37057952oar
oars46846032oars
oat39888262oat
oba57531552oba
obe56638642obe
obi57127732obi
oca56731732oca
od39255242o_d
oda48133042oda
odd57725452odd
ode47446582ode
odic74920572odic
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
off96331632off
oft67744062oft
ogre56320742ogre
oh57447002o_h
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
oka76926802oka
oke75839482oke
okra86413572okra
old47033462old
ole37155212ole
om48553002o_m
oms56337512oms
on28057182o_n
once65423082once
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
ope56845242ope
ops56641252ops
opt57545542opt
orach105219232orach
orad56031692orad
oral47638122oral
orbs66626252orbs
orby97519602orby
orcas75918622orcas
orcin72716572orcin
ordo54622352ordo
ores46056682ores
orgic8311822orgic
orgy85218002orgy
orle45630462orle
orra46120722orra
orts46538332orts
oryx14510212oryx
orzo134516782orzo
os211359882o_s
ose38147342ose
otic66624822otic
ouch95724632ouch
oud47439072oud
our36042892our
ours47237562ours
out38072152out
ova66823792ova
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pac79054082pac
pec76744412pec
pic76046822pic
porch125918622porch
pore66451262pore
pork106929682pork
porn65636022porn
port66059632port
pro55837262pro
pry85728052pry
re26153742_re
rec55645462rec
rob56754302rob
rock105735182rock
rocs65533662rocs
rod47953892rod
roe36861082roe
rom59855632rom
rot37282952rot
row67453672row
sac57452862sac
sec55945322sec
sic55847872sic
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sori46039842sori
sorn46641062sorn
sort46264812sort
sri35634002sri
tic56343462tic
tor39261682tor_
tora47545992tora
torch107420932torch
torcs75123762torcs
tore47359322tore
tori47542152tori
toric76529312toric
torn46044252torn
toro48045682toro
torr45630902torr
tors46157382tors
tort46967462tort
tory75840542tory
try66529672try
urb55731112urb
urd46427052urd
uric63624942uric
urn35731472urn
urp56426402urp
vac86537142vac
word89832002word
wore77144672wore
work115528842work
worm96129492worm
worn75631752worn
wort76654752wort
wry96524702wry
yore76335942yore
zoic152316072zoic
zori137722922zori

Search took 1 second 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 Filter178691140840.266671770.7
2DLD Change Limit140842470.64022006.3
3Display Results2472470.0465369.6
 (SQL Overall)1786912470.952187700.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.