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

116 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
cornicles136824(None) 
cornices12713291cornic_es
corniches1666671corniches
cornicle1258781cornicle_
bernicles1345402bernicles
chronicles1744382chronicles
coracles121811162cor_acles
cornice11612932cornic_e_
corniced1368592cornic_ed
corniche1575922corniche_
cornifies1439002cornifies
cortices12615012cortic_es
curricles13105422curricles
fornices1369102fornic_es
vernicles1446132vernicles
articles10310243_articles
auricles10138333aur_icles
barnacles1355333barnacles
bernicle1245443bernicle_
bornites10310983borni_tes
calicles123811433c_alicles
canticles1339183canticles
carices114220953car_ic_es
carioles10817073car_ioles
carnies94123963carni__es
carnifies1439893carnifies
carrioles1169473carrioles
caruncles1345003caruncles
caulicles1344383caulicles
cenacles1238023c_enacles
cervices1537133cervic_es
chenilles1444373chenilles
chicles143512503c__hicles
chronicle1644233chronicle_
chronicled1842773chronicled
chronicler1752873chronicler
chroniclers1852293chroniclers
circles1139903cir__cles
clavicles1643673clavicles
codices12512583co_dic_es
cognises11610043cogni_ses
cognizes2058033cogni_zes
coincides1446433coincides
comingles1444723comingles
compiles14311983compi_les
conches144019813co_n_ches
condoles113015803co_ndoles
condyles14277463co_ndyles
conics103920593co_nic__s
conies84338593co_ni__es
coniines10415363co_niines
conines93827793co_ni_nes
conioses10313313co_nioses
connives1339723conni_ves
consoles103216153co_nsoles
coppices1638243coppic_es
coprinces1547483coprinc_es
coquilles2044103coquilles
coracle112011723cor_acle_
corbeilles1443813corbeilles
corbies113520123corbi__es
cordelles1248233cordelles
cordials1139623cordial_s
cordites11314623cordi_tes
cornballs1346313cornballs
corncakes1745013corncakes
corncobs1444723corn_cobs
cornels94716663corn_el_s
cornetcies1445843cornetcies
cornfields1641753cornfields
cornichon1642883cornichon
cornichons1743153cornichons
cornicing1439043cornicing
cornier93017093corni__er
corniest102117303corni__est
cornified1546623cornified
cornily12410853corni_l_y
corniness112611183corniness
cornpones1347113cornpones
cornuses10310033corn_uses
corpuscles1642623corpuscles
corries94026793corri__es
corticose1346043corticose
councils1246973council_s
cringles11329463c_ringles
crinkles14269163c_rinkles
cronies9622503croni__es
cubicles1435883c_ubicles
curlicues1343343curlicues
curricle12145933curricle_
cuticles1237893c_uticles
dornicks1544403dornic_ks
follicles1444103follicles
fornicates1545843fornicates
funicles13246833_funicles
horribles14113973horribles
monocles12310673mo_nocles
mortices12711563mortic_es
oracles93212423_or_acles
orioles7412993_or_ioles
ornithes1136423_ornithes
orrices9129363_orric_es
ossicles1054183_ossicles
panicles121010113_panicles
particles1339803particles
popsicles1543663popsicles
porticoes1348253porticoes
sanicles10149943_sanicles
tornillos953693tornillos
tunicles10217133_tunicles
utricles1037223utr_icles
vernacles1445073vernacles
vernicle1346433vernicle_
versicles1446353versicles
vortices1369123vortic_es
zorilles1736123zor_illes

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411167.09320956.0
3Display Results1161160.0502320.0
 (SQL Overall)1786911167.56323627.0
 
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.