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

474 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
orache11401359(None) 
orach105219231orach_
oraches124216471oraches
oracle84313291oracle
ache96829822__ache
apache134210772apache
brace95629272brac_e
brach126123302brach_
braches144621222braches
brachet144020312brachet
brachs134415752brachs
broche133612102broche
cache125122482_cache
coracle112011722coracle
creche13310762creche
drachm1436492drachm
earache1239322earache
gouache1335032gouache
grace85124542grac_e
mache125925302_mache
oracles93212422oracles
orange74016322orange
orate55133302ora_te
race66746262_rac_e
rachet115028972_rachet
raphe104916422_raphe
rathe85821922_rathe
roach105717002roach_
roached133211832roached
roaches123616212roaches
rotche114311982rotche
rouche114714312rouche
ruche104216762_ruche
soroche1237182soroche
tache106222372_tache
trace75829612trac_e
trachea12311672trachea
trachle12311852trachle
tranche123312222tranche
troche113112512troche
ace59656833__ac_e
ached119227833__ached
aches106132293__aches
achy126316093__achy
acme86924323__acme
acne66625873__acne
acre67330773__acre
apace94718383apac_e
apaches143411833apaches
arable81821003arable
arame75026623ara_me
arcade91013643arcade
arcane81216743arcane
arch98628443ar_ch_
arched125717323ar_ched
archer115016243ar_cher
arches114822043ar_ches
attache12106693attache
bach116131393_bach_
bached145519893_bached
baches135426943_baches
bathe105822883_bathe
beach124623893beach_
beached154516553beached
beaches144120653beaches
beachy164011253beachy
berdache1644033berdache
bobeche1643843bobeche
boche124216953_boche
boraces113716853boraces
boracic1338723boracic
boracite1249193boracite
borage93917013bora_ge
borane84620213bora_ne
borate85026153bora_te
borsch1336133borsch_
borsches1536003borsches
borscht1445993borscht
braced115420603braced
bracer104620583bracer
braces108427773braces
brachets154311983brachets
brachia141910423brachia
bracken15409813bracken
bracket154117233bracket
bract96332723brac_t
bracted12410933bracted
bracts105617773bracts
brae65639113bra__e
braise84318753braise
braize174113113braize
brake116025343bra_ke
branch134014773branch_
branched163210453branched
branches153613803branches
branchy17357913branchy
brash106221563brash_
brasher124515243brasher
brashes124518463brashes
brashy145210593brashy
brave104925503bra_ve
braze165423453bra_ze
breach134213723breach_
breached163411643breached
breacher153011503breacher
breaches153714123breaches
breathe123711843breathe
brioche14275923brioche
broach133611113broach_
broached16309123broached
broacher15329263broacher
broaches153211623broaches
cached145419203_cached
caches137926913_caches
cachet134526413_cachet
caroche1469243caroche
clach124617823clach_
clachs133511323clachs
cliche133712453cliche
cloche134312373cloche
coach125919453coach_
coached153313843coached
coacher143714123coacher
coaches144018693coaches
coracles121811163coracles
corniche1575923corniche
crack134120533crac_k
cracked163514743cracked
cracker153114173cracker
crackle153611253crackle
cracks144817003cracks
cracky175010223cracky
cradle93313163cradle
crake114823523cra_ke
crambe1239073crambe
cranch133613533cranch_
cranched163210413cranched
cranches153114543cranches
crane75331603cra_ne
crape96128443cra_pe
crash109120013crash_
crashed134214203crashed
crasher124616163crasher
crashes124618403crashes
cratch134110793cratch_
cratches153012543cratches
crate76537403cra_te
crave105626313cra_ve
craze165221463cra_ze
creches14313093creches
crochet143616663crochet
dace76934923_dac_e
dacha114812573_dacha
douche124613223douche
drachma1544303drachma
drachmae1643933drachmae
drachms1534253drachms
dragee84415603dragee
drake104918303dra_ke
drape85319633dra_pe
drave95219273dra_ve
drawee104413823drawee
each95530583_each_
earaches13411303earaches
eche97520283__eche
erase54925493era_se
face96140123_fac_e
farce104925323farc_e
farcie114816473farcie
fiacre1137623fiacre
fiche134616743_fiche
fleche14299303fleche
forage104617003fora_ge
force105324273for_c_e
fracas11311993fracas
fracted1339373fracted
fracti1139963fracti
frae75330473fra__e
fraise94214913fraise
frame105821803fra_me
frappe13286953frappe
ganache1346203ganache
gauche1238553gauche
glace87420153glac_e
gouaches1436193gouaches
graced105217903graced
graces94523493graces
gracile102512603gracile
grackle14338893grackle
grade75126093gra_de
gramme114210333gramme
grange83716203grange
grape84824663gra_pe
graph115315613graph_
graphed1498473graphed
graphs124510153graphs
grate64932883gra_te
grave94624873gra_ve
graze155820053gra_ze
horah117922053hora_h_
horahs126313873hora_hs
huarache1644313huarache
irade65618153ira_de
irate55627983ira_te
kwacha1832983kwacha
lace66848473_lac_e
laches116528343_laches
larch105919793larch_
larchen12479623larchen
larches124416443larches
lathe85626713_lathe
leach105422523leach_
leached133715043leached
leacher124014843leacher
leaches123319343leaches
leachy14419733leachy
loach105116363loach_
loaches123613983loaches
loathe94211383loathe
loricae938253loricae
louche115212663louche
mace87345793_mac_e
mach116134483_mach_
maches134827233_maches
macho126120153_macho
machs125722563_machs
macle96127003_macle
manche133515103manche
march125622893march_
marched153813403marched
marchen143312073marchen
marcher143912973marcher
marches143921173marches
miche126219243_miche
miracle1138843miracle
morae75831193mora__e
moraine9314573moraine
morale85220553mora_le
naches114622413_naches
nacho105414383_nacho
nacre75715363_nacre
niche105016793_niche
oath76132153o_ath_
oaths86117313o_aths
ocher104516103o__cher
ochre103411593o__chre
odah87018933oda_h_
odahs95610083oda_hs
once65423083o_nc_e
opah96218403opa_h_
opahs105411983opa_hs
opaque1734213opaque
ora37250833ora___
orad56031693ora__d
oral47638123ora__l
orally93113593orally
orals55826483ora_ls
orang65119943ora_ng
oranges84215333oranges
orangey11388833orangey
orangs74116033orangs
orangy105111233orangy
orated74221503orated
orates64328613orates
orator6314533orator
orc57034923or_c__
orca65522773or_c_a
orcas75918623or_cas
orchid1289573or_chid
orchil1158653or_chil
orchis11710773or_chis
orcin72716573or_cin
orcs67025433or_c_s
ordure756813ordure
ore36661833or___e
oreide7311673oreide
orgone71110913orgone
oriole6814293oriole
orisha936773orisha
orle45630463or__le
ornate6315133ornate
oroide7311703oroide
orpine83914483orpine
orrice81410163orrice
ortho8312293or_tho
ouch95724633o_uch_
ouched124316933o_uched
ouches114322183o_uches
ounce77019933ounc_e
ouphe104413263o_uphe
outrace92418553outrac_e
ovate84214393ova_te
pace86345773_pac_e
pacha126518063_pacha
panache1458423panache
parch125123003parch_
parched154013693parched
parches143720003parches
peace95026083peac_e
peach125422493peach_
peached154315883peached
peacher144216073peacher
peaches144120053peaches
peachy164510843peachy
place94824613plac_e
planche14299753planche
poach124917863poach_
poached154212403poached
poacher143912323poacher
poaches144416943poaches
poachy16388963poachy
pomace123111913pomac_e
porch125918623por_ch_
porches143815673por_ches
potiche1438043potiche
potlache15114283potlache
prahu105013973pra_hu
praise84419413praise
prance104318573prance
prase76128753pra_se
prate75135983pra_te
preach133613923preach_
preached163412063preached
preacher153211373preacher
preaches153214893preaches
preachy17307313preachy
price93725413pric_e
psyche1674293psyche
quiche2057903quiche
raced87635313_raced
raceme1039733_raceme
racer75233023_racer
races74943243_races
rachets124516833_rachets
rachis114017653_rachis
racier85120973_racier
rack106234883_rac_k
racked134526083_racked
racker124824553_racker
racket125229423_racket
rackle123917293_rackle
racks115028853_racks
racon75422143_racon
racy95825683_rac_y
rage55742353_ra_ge
ragee65432663_ragee
rah68052403_ra_h_
raise54828053_raise
rake84841573_ra_ke
rakee96031173_rakee
rale45050563_ra_le
ramee74633853_ramee
ramie75027823_ramie
rance75028513_rance
ranch105019793_ranch_
ranched133113603_ranched
rancher123013633_rancher
ranches123620113_ranches
rancho114310853_rancho
ranee55438103_ranee
range64728413_range
rape65041633_ra_pe
raphae114311733_raphae
raphes115117453_raphes
rare45348433_ra_re
rase46149983_ra_se
rash76039933_rash_
rasher95024123_rasher
rashes95330153_rashes
ratch104221363_ratch_
ratches123620463_ratches
ratchet124218333_ratchet
rate45458763_ra_te
rath76037663_rath_
rather94319743_rather
rave75542093_ra_ve
raze135235433_ra_ze
razee145827803_razee
reach105123883reach_
reached134619083reached
reacher123718293reacher
reaches123423203reaches
recce9514563_recce
rechew14310213_rechew
rhaphe1433423rhaphe
rice64942913_ric_e
rich97025543_rich_
richen113812513_richen
richer114015043_richer
riches115022083_riches
roadie72813813roadie
rochet115423003_rochet
roscoe839763roscoe
rotch105815933rotch_
rotches123515703rotches
rouches124217893rouches
ruched124314633_ruched
ruches114819583_ruches
sachem134012223_sachem
sachet114725773_sachet
sadhe94815133_sadhe
scathe114414993scathe
seiche11811833seiche
snathe94415113snathe
solace83415823solac_e
soroches1338803soroches
soutache1344983soutache
space95325673spac_e
spathe115115693spathe
sradha1085333sradha
stacte82113913stacte
swathe125514113swathe
tace65342513_tac_e
tach96132753_tach_
taches114224173_taches
tachs105820933_tachs
teach105221123teach_
teacher123714833teacher
teaches122718353teaches
torah87125273tora_h_
torahs95115643tora_hs
torch107420933tor_ch_
torched133511353tor_ched
torches123715433tor_ches
torchy14549533tor_chy
touche114916173touche
traced94821583traced
tracer84820233tracer
traces85329933traces
tracheae1349113tracheae
tracheal1348253tracheal
tracheas13410273tracheas
tracheid1437583tracheid
trachled1438313trachled
trachles13311753trachles
trachyte1645943trachyte
track114823013trac_k
tracked143716133tracked
tracker133515173tracker
tracks124818843tracks
tract75635713trac_t
tracts85019073tracts
trade65026043tra_de
trance84718763trance
tranches132915513tranches
trash86119763trash_
trashed113514703trashed
trasher104416133trasher
trashes104119263trashes
trashy12509053trashy
trauchle1344963trauchle
trave85223033tra_ve
treacle939973treacle
trice75127493tric_e
trochee122613883trochee
troches123715343troches
truce75118693truc_e
tusche1136783tusche
uracil8311543uracil
urare56322553ura_re
urase54624683ura_se
urate55432163ura_te
wacke145918623_wacke
wrack145413883wrac_k
wracked174110113wracked
wracks154711113wracks
wrasse9398773wrasse
wrath115715873wrath_
wrathed14298523wrathed
wraths123810083wraths
wrathy15377853wrathy
wreathe13339053wreathe
writhe125310703writhe
yacht13417393_yacht

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 Limit1127164748.23613685.8
3Display Results4744740.1563038.5
 (SQL Overall)1786914748.53220943.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.