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

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
conceal11331301(None) 
conceals123111011conceals
conchal144211581conchal
congeal104011681congeal
cancel105316682cance_l
coccal9310222co_ccal
concealed1458132concealed
concealer1368222concealer
concede12310102concede
conceit113218072conceit
concent114422512concent
concept133314442concept
concern113011962concern
concert113325222concert
concha134213282concha_
conchae143911642conchae
conchas144013312conchas
congeals11309852congeals
conical11316202conical
corneal94414502corneal
cornmeal1245852cornmeal
cuneal8611512cun_eal
anconeal1045593ancon_eal
anneal64812293_anneal
apneal83411123apn_eal
apnoeal956193apnoeal
bonemeal1245163bonemeal
boreal84817213bo_real
caecal103713733caec_al
calyceal1543043calyceal
canal75428043can__al
cancan10314103canc_an
cancels114113313cancels
cancer104220923cance_r
cancers114018583cancers
cancha134411613cancha_
canchas143212403canchas
candela1089743candela
cannel84216403canne_l
cantal84122033can_tal
canthal12410053canthal
carcel105018673carce_l
carceral1247203carceral
cecal94619113c_ec_al
censual937663censual
cental84420963cen_tal
central93114473central
cercal10314123cerc_al
cereal8315833c_ereal
chancel144011773chance_l
choreal124412223choreal
cineol8108203cin_eol
cloacal1135163cloac_al
clonal8310913clon__al
clypeal1443513clypeal
coaeval1245183coaeval
coal66939253co___al
coastal9411043coastal
coaxal15387303co_axal
coaxial16157003coaxial
coca88030643co_c_a_
cocas95926573co_c_as
coccygeal1651023coccygeal
cocoa98517883co_coa_
cocoas104915743co_coas
coequal1844933coequal
coeval1138893co_eval
cohead123811123co_head
coital84117053co_ital
colead94114643co_lead
comal95125133co__mal
comical13312223comical
compel124412893compe_l
concave1439373concave
concealers1476913concealers
concealing1549303concealing
conceded1438293conceded
conceder1338743conceder
concedes13311063concedes
conceits122813613conceits
conceive1539233conceive
concents122516603concents
concepti14328273concepti
concepts143110303concepts
conceptual1655323conceptual
concerns122710833concerns
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
conch124620073conc__h
conches144019813conches
conchie143312683conchie
concho134414263conc_ho
conchos144313963conchos
conchs134714903conc_hs
conchy163710223conc_hy
concise11314473concise
conclave1556403conclave
concoct10312903concoct
concord12510343concord
concordal1445323concordal
concrete12411083concrete
concur10411103conc_ur
concurs11311473concurs
concuss1138063concuss
condemn1237113condemn
cone67256963con_e__
coned86040053con_e_d
conepatl1286703conepatl
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confab1347063con_fab
confect143614273confect
confer114018683confe_r
conferral1446323conferral
confers124120093confers
conferval1745563conferval
confess12399903confess
confocal1546303confocal
conga85419873con_ga_
congaed11399743congaed
congas94417033con_gas
conge85227593conge__
congealed1346593congealed
congealer1256703congealer
congee96024473conge_e
congeed113212313congeed
congees103517923congees
congenial1248813congenial
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congest104618773congest
conidial1159503conidial
conies84338593conie_s
conjugal1843513conjugal
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
connect113515743connect
conned95119703conne_d
conner84423963conne_r
conners94023113conners
conoidal1149013conoidal
consent93723113consent
consol82614113con_sol
consul82312303con_sul
conte76633203conte__
contemn1137803contemn
contend103511893contend
content94326153content
contes84432913conte_s
contest93523233contest
context163913433context
contra83314703contra_
contrail10410983contrail
contras93015623contras
control9310693control
convect143114483convect
convene123314323convene
convent123919413convent
convert123721473convert
convex18367743conve_x
convexly2343783convexly
convey144610223conve_y
conveys15308223conveys
cooncan1147233coonc_an
copal95621783co__pal
coral76033453co__ral
corbeil11859213corbeil
corbel103715973corbe_l
cordial10312943cordial
cormel103815603corme_l
cornea84018923cornea_
corneas94717003corneas
cornel84020053corne_l
cornmeals1344573cornmeals
cornual94210173cornual
coronal94115763coronal
corral83616253co_rral
coryzal2154823coryzal
costal85419513co_stal
coteau8311083co_teau
cotidal1038463cotidal
council1137473counc_il
counsel948543counse_l
couteau938833couteau
cowbell1445223cowbell
cowpea1337643cowpea_
cowpeas1437273cowpeas
coxal146116673co__xal
crucial1157893crucial
cynical1437873cynical
donzel1636313donze_l
focal104917673fo_c_al
fontal9313143fon_tal
foveal1237703fo_veal
gonadal956523gonadal
iconical1248203iconical
lineal65616023lin_eal
local74820273lo_c_al
loreal63814313lo_real
lyncean1292923lyncean
monachal1545703monachal
monadal1047893monadal
morceau1145573morceau
nonce75719823nonce__
noncereal1157743noncereal
nonces84418833nonce_s
noncola948293noncola
nonideal947303nonideal
nonlegal946073nonlegal
nonmeat9312773nonmeat
nonmetal1049643nonmetal
nonoral7313603nonoral
nonpeak1345473nonpeak
ocean71212963_o_cean
octal71214723_o_ctal
once65423083_once__
oncet74626543_once_t
ordeal779253_ordeal
osteal6312963_osteal
pencel103812913pence_l
pineal84817683pin_eal
ponce95222513ponce__
ponced114314813ponce_d
ponces104720843ponce_s
rhonchal1642673rhonchal
rondeau846813rondeau
rondel73212643ronde_l
ronnel63310883ronne_l
sconce104711723sconce__
sconced12359173sconce_d
sconces113811453sconce_s
social8813333so_cial
tincal83913363tinc_al
tineal66216163tin_eal
tonal53724303ton__al
tonneau765913tonneau
uncial83715223_uncial
unreal64414453_unreal
unseal63315473_unseal
vineal94814743vin_eal
vocal104715643vo_c_al
zoeal144813783zo__eal
zonal145116853zon__al

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272476.23621492.5
3Display Results2472470.0932655.9
 (SQL Overall)1786912476.73226543.5
 
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.