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

155 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
conchal14421158(None) 
conceal113313011conceal
concha134213281concha_
conchae143911641conchae
conchas144013311conchas
cancha134411612cancha_
canchas143212402canchas
canthal12410052canthal
coccal9310222co_ccal
conceals123111012conceals
conch124620072conch__
conches144019812conches
conchie143312682conchie
concho134414262conch_o
conchos144313962conchos
conchs134714902conch_s
conchy163710222conch_y
congeal104011682congeal
conical11316202conical
monachal1545702monachal
rhonchal1642672rhonchal
benthal1247953benthal
bronchial16175333bronchial
caecal103713733caec_al
canal75428043can__al
cancan10314103canc_an
cancel105316683canc_el
cantal84122033can_tal
catchall1546233catchall
cecal94619113c_ec_al
censual937663censual
cental84420963cen_tal
central93114473central
cercal10314123cerc_al
cinch124516243cinch__
cinched153910863cinched
cinches144215773cinches
clachan1437183clachan
cloacal1135163cloac_al
clonal8310913clon__al
coach125919453coach__
coachable1846303coachable
coached153313843coached
coacher143714123coacher
coaches144018693coaches
coachman1744983coachman
coaeval1245183coaeval
coal66939253co___al
coanchor1545253coanchor
coastal9411043coastal
coaxal15387303co_axal
coaxial16157003coaxial
coca88030643co_c_a_
cocas95926573co_c_as
cochair1446313co_chair
cochin131313203co_chin
cocoa98517883co_coa_
cocoas104915743co_coas
coequal1844933coequal
coeval1138893co_eval
coital84117053co_ital
comal95125133co__mal
comical13312223comical
concave1439373concave
concealed1458133concealed
concealer1368223concealer
concede12310103concede
conceit113218073conceit
concent114422513concent
concept133314443concept
concern113011963concern
concert113325223concert
conchies153214853conchies
conchoid1688043conchoid
conchoidal1853543conchoidal
concise11314473concise
conclave1556403conclave
concoct10312903concoct
concord12510343concord
concordal1445323concordal
concur10411103conc_ur
concurs11311473concurs
concuss1138063concuss
conepatl1286703conepatl
confab1347063con_fab
confocal1546303confocal
conga85419873con_ga_
congas94417033con_gas
congeals11309853congeals
conidial1159503conidial
conjugal1843513conjugal
conoidal1149013conoidal
consol82614113con_sol
consul82312303con_sul
contra83314703contra_
contrail10410983contrail
contras93015623contras
control9310693control
cooch124916833cooch__
cooches143515833cooches
cooncan1147233coonc_an
copal95621783co__pal
coral76033453co__ral
cordial10312943cordial
corneal94414503corneal
cornmeal1245853cornmeal
cornual94210173cornual
coronal94115763coronal
corral83616253co_rral
coryzal2154823coryzal
costal85419513co_stal
cotidal1038463cotidal
couch125320113couch__
couchant1549053couchant
couched154115793couched
coucher144515853coucher
couches144020473couches
council1137473counc_il
coxal146116673co__xal
crucial1157893crucial
cuneal8611513cun_eal
cynical1437873cynical
epochal1445243epochal
focal104917673fo_c_al
fontal9313143fon_tal
gonadal956523gonadal
gotcha1234633gotcha_
gotchas1334613gotchas
honcho14389383honch_o
honchos15369573honchos
iconical1248203iconical
local74820273lo_c_al
lochan1139093lo_chan
lochial1257083lo_chial
mocha1249923mo_cha_
mochas13310663mo_chas
monadal1047893monadal
monarchal1643973monarchal
noncola948293noncola
nonoral7313603nonoral
nuchal11218873_nuchal
octal71214723_o_ctal
orchil1158653_orchil
panchax2134983panchax
paschal14157243paschal
poncho133310123ponch_o
ponchos143410703ponchos
rhonchial1752263rhonchial
social8813333so_cial
tincal83913363tinc_al
tonal53724303ton__al
trochal1288243trochal
uncial83715223_uncial
vocal104715643vo_c_al
zonal145116853zon__al

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271557.65617506.1
3Display Results1551550.0602583.3
 (SQL Overall)1786911558.12222000.9
 
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.