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

449 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
caroch1391176(None) 
caroach1488861caroach
caroche1469241caroche
carroch1437091carroch
arch98628442_ar_ch
capouch1644412capouch
caprock1736812caprock
carack142113172carack
carioca1139682carioca
carob95325222caro_b
carobs104818102carobs
caroches15710692caroches
carol75128612caro_l
caroli85918232caroli
carols85124982carols
carom95025562caro_m
caroms105619572caroms
cartouch15113492cartouch
catch125120372ca_tch
cooch124916832c_ooch
cranch133613532cranch
cratch134110792cratch
croc85723732c_roc_
croci95818132c_roci
crock135921992c_rock
crocs95722432c_rocs
crotch133410082c_rotch
crouch133910202c_rouch
curch124415412cur_ch
larch105919792lar_ch
march125622892mar_ch
parch125123002par_ch
taroc75721642taroc_
tarocs84615662tarocs
aargh96314083aar_gh
aarrgh10786303aarrgh
abroach1446213abroach
acaroid103512303acaroid
acock132110213_acock
across8312643across
aitch105216163_aitch
anarch11310393anar_ch
arc510250903_ar_c_
arco68331543_ar_co
arcs67834783_ar_cs
areca75618633_areca
aroid65428333_aroid
aroma71220143_aroma
arose55832083_arose
aurochs1245983aurochs
avouch1434833_avouch
azoth17389903_azoth
bach116131393ba__ch
barca91319433bar_ca
baric96125693baric_
baron78131243baro_n
barong96015823barong
barons85025383barons
barony115915303barony
barouche1544173barouche
batch124620103ba_tch
birch124914023bir_ch
borsch1336133borsch
brach126123303_brach
branch134014773branch
broach133611113_broach
broche133612103_broche
brock136017073_brock
brooch13368443brooch
broth106521093_broth
cabob114616803cabo_b
cabobs124311883cabobs
caboched1844043caboched
cabochon1742763cabochon
caca85528083ca__ca
cache125122483ca__che
caeca93915133ca_eca
caeoma1039033caeoma
cahoot11416473cahoot
cahow135110943caho_w
cahows14399123cahows
cajole154011183cajole
cajon144513903cajo_n
calash11312433calash
caleche14297943caleche
caliche14329953caliche
calico103414433calico
caliph13311403caliph
calo64936443calo__
calory11312843calory
calos74431903calo_s
camo85731753camo__
camos95927613camo_s
cancha134411613ca_ncha
canoe75627253cano_e
canoed94618953canoed
canoer85121073canoer
canoes84725883canoes
canola8313623canola
canon74725303cano_n
canons85522063canons
canopy1337723canopy
caph116623293ca__ph
capo85829213capo__
capon95221873capo_n
capons104119503capons
capos94826073capo_s
capote10315733capote
capric12411793capric_
caprice1349683caprice
caprocks1835943caprocks
capuche1644433capuche
car59165563car___
caracal11312513caracal
caracks152211563caracks
caracol11310423caracol
caracul1138823caracul
carafe115416163carafe
carat75048793car_at
carate84734003carate
carats85929023carats
carb85143163car__b
carbo94923843car_bo
carbon104919043carbon
carbons115418943carbons
carbora11310703carbora
carbos105122263carbos
carboy134914183carboy
carboys144711783carboys
carbs96031463car_bs
carcel105018673carcel
card710245873car__d
carded105424903carded
carder94524183carder
cardia9916373cardia
cardio9915673cardio
cardon94120853cardon
cardons104519933cardons
cardoon104813813cardoon
cards85137933car_ds
care66968373car__e
cared86050093car_ed
careen84119493careen
career85822243career
carer74942333car_er
carers85133953carers
cares77369183car_es
caress85720263caress
caret75360563car_et
carets85330773carets
carex144822293car_ex
carful11610973carful
cargo85322073car_go
cargoes104415223cargoes
cargos94619183cargos
carhop133610763carhop
carhops14329703carhops
caribe103416743caribe
carices114220953carices
caried94528693caried
caries85147623caries
carina84325323carina
caring95137993caring
cariocas1239663cariocas
cariole9818343cariole
carious93320283carious
carjack2246153carjack
cark105539273car__k
carked134024823carked
carks115534213car_ks
carl65144783car__l
carle74535703car_le
carles85435083carles
carlin84421823carlin
carlish12312763carlish
carload1039783carload
carls77037423car_ls
carman103920743carman
carmen104019343carmen
carn66245433car__n
carnal83919203carnal
carnet84732873carnet
carney115315703carney
carnie84421093carnie
carns75937563car_ns
carny105822923car_ny
caroaches1637793caroaches
caroled103717683caroled
caroler93816753caroler
carolus94612603carolus
caromed123713623caromed
carotid102014813carotid
carotin92216713carotin
carouse9614423carouse
carp85139813car__p
carpal103716253carpal
carped115923763carped
carpel105418473carpel
carper104923633carper
carpet104530093carpet
carpi94319393car_pi
carpool1139223carpool
carport11316033carport
carps96932253car_ps
carpus105514303carpus
carr65434703car__r
carrack1548753carrack
carrel84718633carrel
carritch1543483carritch
carroches1665893carroches
carrom10513403carrom
carroms11512403carroms
carrot8423123carrot
carrots9714623carrots
carroty1248943carroty
carrs75730853car_rs
carry105823783car_ry
cars67364763car__s
carse74934333car_se
carses85233653carses
carsick1536343carsick
cart66570343car__t
carte75940423car_te
carted98631443carted
cartel85022533cartel
carter84932273carter
cartes86239473cartes
carton84522663carton
cartons94122473cartons
cartoon94114463cartoon
cartop104213563cartop
cartouche16122563cartouche
carts78946293car_ts
carve106227753car_ve
carved124320853carved
carvel114817573carvel
carven114716663carven
carver114420143carver
carves115128453carves
carwash1535993carwash
casbah1337903casbah
cash96636283ca__sh
cassock1545953cassock
catchy16559583ca_tchy
catechu1444473catechu
cavort11316173cavort
cerci93716393cer_ci
ceric94023093ceric_
ceriph1398463ceriph
cero66329453cero__
ceros74726073cero_s
cerous85821203cerous
chaloth15298603chaloth
charlock1944393charlock
chinch163911223chinch
chock164316613c_hock
chroma132912473chroma
chrome133214813chrome
chromo132811013chromo
chromy16309903chromy
church1636483church
cinch124516243c_inch
circa9311403cir_ca
clach124617823c_lach
claro75018693claro__
claroes93113733claroes
claros84015113claro_s
clench133910053clench
clinch133910353clinch
cloche134312373c_loche
clock134917983c_lock
cloth105817543c_loth
clutch13367753clutch
coach125919453c_oach
coca88030643c__oca
cock126332903c__ock
coco87330603c__oco
cohosh14517123cohosh
conch124620073c_onch
corody12149703corody
corona83817403corona
coronach1545763coronach
cosh96127623c__osh
couch125320113c_ouch
crack134120533c_rack
crash109120013c_rash
craunch1464443craunch
creche13310763c_reche
crick135118753c_rick
croak115216633c_roak
crochet143616663c_rochet
crocks145118423c_rocks
crocus104813173c_rocus
croft105622683c_roft
crone75231333c_rone
crony105918673c_rony
crook115217573c_rook
croon75522783c_roon
crop87628633c_ro_p
crops96125233c_rops
crore74922863c_rore
cross75124503c_ross
croup95616783c_roup
crow96428133c_ro_w
crowd115815623c_rowd
crown105620083c_rown
crows105727313c_rows
croze164719453c_roze
cruck135615323c_ruck
crunch13349503crunch
crush106815993c_rush
crutch13408243crutch
crwth1337483c_rwth
culch124512833c_ulch
cultch13385953cultch
curacy1339593curacy
curagh1236553curagh
currach1446453currach
cutch125116193c_utch
daric85623113daric_
darics94314113darics
duroc84513143duroc_
durocs9569703durocs
each95530583ea__ch
earache1239323earache
earlock1336923earlock
earth85023053ear_th
enrich1138943enrich
eparch13258423epar_ch
epoch1248203_epoch
exarch18196173exar_ch
farce104925323far_ce
farci105919313far_ci
farcy135217093far_cy
faro76136923faro__
faros85532023faro_s
farouche1643053farouche
frock145314653_frock
frosh115713403_frosh
froth115919283_froth
galosh1038553galosh
garcon92912483garcon
garish104516923garish
garote7717943garote
garth94720223gar_th
grouch12318473_grouch
harsh116418053har_sh
hatch135719593ha_tch
haunch14377343haunch
havoc1337183havoc_
havocs1435653havocs
hooch135813703_hooch
inarch1139163inar_ch
jarrah1636683jarrah
karoo92519583karo_o
karoos102415803karoos
kaross101910013kaross
kirsch1532713kirsch
laich105920713la_ich
latch104620463la_tch
launch11368063launch
lavrock1644223lavrock
liroth938383liroth
loch95527133__loch
lurch104814633lur_ch
mach116134473ma__ch
maraca10314153maraca
marc87034623mar_c_
marcs95726623mar_cs
marish114319053marish
maroon83118203maroon
marsh105320853mar_sh
match125621103ma_tch
merch125417963mer_ch
moloch1356483moloch
mooch125313613_mooch
narc67127953nar_c_
narco76718243nar_co
narcos86714203narcos
narcs76122023nar_cs
naric76824173naric_
natch105018223na_tch
nautch1144813nautch
oarlock1336123oarlock
orach105219233_orach
painch133511323painch
panocha1444983panocha
panoche1456383panoche
paraph13311263paraph
pardah123412823pardah
pariah114320583pariah
parish115022353parish
parody12410093parody
parol74826273paro_l
parole84425253parole
parols84722613parols
parous84024163parous
patch125221223pa_tch
paunch13369853paunch
perch124518833per_ch
pibroch1643803pibroch
pooch124815303_pooch
porch125918623por_ch
ranch105019793ra_nch
ratch104221363ra_tch
raunch11358433raunch
rich97025543__rich
roach105717003__roach
roc520243253__roc_
rock105735183__rock
rocs65533663__rocs
rotch105815933__rotch
samech13277033samech
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
sauch104918773sa_uch
scarce104013633scar_ce
scarph13429603scar_ph
scooch13228123scooch
scorch13198093scor_ch
scraich1436763scraich
scratch1446013scratch
scrooch1444953scrooch
search113312423sear_ch
smooch13266803smooch
soroche1237183soroche
starch113013203star_ch
tach96132753ta__ch
taro46846913taro__
tarok97921073taro_k
taroks106115283taroks
taros55640823taro_s
tarot55943933taro_t
tarots66422993tarots
torch107420933tor_ch
toroth95512963toroth
troche113112513_troche
trock114817603_trock
troth85622203_troth
varoom11411413varoom
warlock1636293warlock
warmth1477933warmth
watch135617063wa_tch
wroth116815883_wroth
yapock17365383yapock
zeroth1837963zeroth

Search took 7 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 Limit1127164496.19018209.4
3Display Results4494490.1532934.6
 (SQL Overall)1786914496.48327563.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.