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

300 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
concho13441426(None) 
conch124620071conch_
concha134213281concha
conchos144313951conchos
conchs134714901conchs
conchy163710221conchy
honcho14389381honcho
poncho133310121poncho
ancho104515302_ancho
broncho14206462broncho
cancha134411612cancha
cinch124516242cinch_
coach125919452coach_
coanchor1545242coanchor
coco87330602co_c_o
coho97524492co__ho
conchae143911642conchae
conchal144211582conchal
conchas144013312conchas
conches144019812conches
conchie143312682conchie
conchoid1688042conchoid
concur10411092concur
condo85322592con_do
congo85623132con_go
conto76027172con_to
cooch124916832cooch_
coocoo1069692coocoo
couch125320112couch_
honchos15369572honchos
ponchos143410702ponchos
rancho114310852rancho
anchor113911973_anchor
anchos114214893_anchos
banco94019393banc_o
bench125619503bench_
boche124216953bo_che
boho96923323bo__ho
bongo85720943bon_go
bonito8313433bonito
bonobo1037143bonobo
boocoo1039003boocoo
botch126717453botch_
botchy16537823botchy
bronchi14176313bronchi
bronchos15206173bronchos
bronco10179493bronc_o
bunch125118603bunch_
bunchy16437463bunchy
bunco94616083bunc_o
cacao95420003c_acao
cache125122483c_ache
cachou13310613c_achou
cancan10314103cancan
cancel105316683cancel
cancer104220923cancer
canchas143212403canchas
canso75019403can_so
canthi11310963canthi
canto74931013can_to
catch125120373catch_
catchy16559583catchy
cento76625173cen_to
chichi1637093chichi
chico124218253chic_o
chinch163911223chinch_
chinchy20335513chinchy
chowchow2482063chowchow
cinched153910863cinched
cinches144215773cinches
cinchona1554403cinchona
cisco95112133cisc_o
clach124617823clach_
clachs133511323clachs
clench133910053clench_
cliche133712453cliche
clinch133910353clinch_
cloche134312373cloche
coached153313843coached
coacher143714113coacher
coaches144018693coaches
coact96130573coac_t
coactor1139113coactor
coacts105314323coacts
coanchors1645713coanchors
coca88030643co_c_a
cocas95926573co_cas
coccal9310223coccal
cocci82812673co_cci
coccic8298943coccic
coccid102910743coccid
coccus979283coccus
coccyx1942663coccyx
cochin131313203co_chin
cock126332903co_c_k
cocks135227163co_cks
cocky164215933co_cky
cocoa98517883co_coa
cocoon10312263co_coon
cocos95624693co_cos
cogito939203cogito
cohog117813043co__hog
cohos105921853co__hos
colugo935863colugo
combo114519433co_mbo
comedo11359603comedo
compo115318573co_mpo
con510268023con___
concave1439373concave
conceal113313013conceal
concede12310093concede
conceit113218073conceit
concent114422513concent
concept133314443concept
concern113011963concern
concert113325223concert
concerto123311613concerto
conchies153214853conchies
conchoids1766263conchoids
concise11314473concise
concoct10312903concoct
concord12510343concord
concurs11311453concurs
concuss1138063concuss
condom114215363condom
condor94616963condor
condos94322333condos
cone67256963con__e
coned86040053con_ed
cones76457423con_es
coney105932883con_ey
coneys115218423coneys
confab1347063confab
confer114018683confer
confit113316403confit
conga85419873con_ga
congas94417033congas
conge85227593con_ge
congee96024463congee
conger95024273conger
conges94928173conges
congii957363congii
congos94219883congos
congou94313243congou
coni65534803con__i
conic95329793con_ic
conical11316203conical
conics103920593conics
conies84338593conies
conin76232723con_in
conine84528553conine
coning94331823coning
conins84327233conins
conium10415313conium
conk106531443con__k
conked135019113conked
conker124721553conker
conks115525703con_ks
conky145818743con_ky
conn66229133con__n
conned95119703conned
conner84423963conner
conns75024233con_ns
conoid9818883conoid
cons66057693con__s
consol82614113consol
consul82312303consul
conte76633203con_te
contes84432913contes
contos84923233contos
contra83314693contra
control9310673control
conus76726533con_us
convex18367743convex
convey144610223convey
convoy14348543convoy
cony96537833con__y
coo59566363co___o
cooches143515833cooches
cooncan1147233cooncan
corncob1345663corncob
corniche1575923corniche
cornichon1642883cornichon
cornuto937023cornuto
cosh96127623co_sh_
couched154115793couched
coucher144515853coucher
couches144020463couches
cough115819643cough_
coughs125514543coughs
council1137463council
couth106122483couth_
couths115715393couths
cranch133613533cranch_
creche13310763creche
crotch133410083crotch_
crouch133910203crouch_
crunch13349503crunch_
crunchy17324763crunchy
culch124512833culch_
curch124415413curch_
cutch125116193cutch_
cyclo1237703c_yclo
douche124613223douche
dunch115316263dunch_
echo96615953__echo
finch135416973finch_
gaucho1256223gaucho
gonzo15310243gon_zo
gotcha1234633gotcha
honchoed1745733honchoed
hooch135813703hooch_
hotch136214723hotch_
hunch136416213hunch_
inch95420823_inch_
jocko184210453jo_cko
junco144612203junc_o
kench145513923kench_
loach105116363loach_
loch95527133lo_ch_
lochs106715513lo_chs
loco67030743lo_c_o
louche115212663louche
lunch104917243lunch_
lynch13468983lynch_
macho126120153_macho
manche133515103manche
mocha1249923mo_cha
mondo85721233mon_do
mongo810122413mon_go
mono66036713mon__o
month104818423month_
months113812933months
mooch125313613mooch_
morpho13158443morpho
mouch124715803mouch_
mucho125013443_mucho
munch124917103munch_
nacho105414383_nacho
nonce75719823nonc_e
nonces84418833nonces
noncom1039683noncom
nonego737013nonego
notch105613323notch_
nuncio837973nuncio
oho66534383_o__ho
once65423083_onc_e
oncet74626543_oncet
ono36838033_on__o
onto46127663_on_to
ortho8312293_ortho
ouch95724633_ouch_
pinch125619303pinch_
poach124917863poach_
poachy16388963poachy
poco86826153po_c_o
ponce95222513ponc_e
ponced114314813ponced
ponces104720843ponces
ponchoed1646133ponchoed
pooch124815303pooch_
porch125918623porch_
pouch124617083pouch_
pouchy16538663pouchy
psycho1674533psycho
punch125118423punch_
punchy16398523punchy
ranch105019793ranch_
ranchos123911393ranchos
reecho11318653reecho
rhonchi1542493rhonchi
roach105717003roach_
rondo65218373ron_do
rotch105815933rotch_
rotche114311983rotche
rouche114714313rouche
sconce104711723sconc_e
sconced12359173sconced
sconces113811453sconces
sconcheon1642373sconcheon
scooch13228123scooch_
scorch13198093scorch_
scotch13207513scotch_
socko115215113so_cko
sorgho10348713sorgho
synch135011793synch_
synchro1544543synchro
synchs14408453synchs
tench105620003tench_
tondo69718683ton_do
torch107420933torch_
torchon1237363torchon
torchy14549533torchy
touch106519393touch_
touche114916173touche
touchy145010503touchy
unco66021403_unc_o
vouch134611903vouch_
wench136214783wench_
winch135016663winch_

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 Limit1127163005.12621989.1
3Display Results3003000.0933225.8
 (SQL Overall)1786913005.35933344.1
 
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.