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 “corniche” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
corniche157592(None) 
cornice11612931cornic_e
corniches1666681corniches
cornicle1258781cornicle
corniced1368602corniced
cornices12713302cornices
cornichon1642882cornichon
cornicles1368252cornicles
bernicle1245443bernicle
bornite9311183borni_te
caliche14329963c_aliche
carnie84421093carni__e
caroche1469243car_oche
ceviche1744143c_eviche
chronicle1644233chronicle
cliche133712453c__liche
cognise1059683cogni_se
cognize1957683cogni_ze
coincide1346493coincide
conch124620073co_n_ch_
concha134213283co_n_cha
conchae143911643co_n_chae
conches144019813co_n_ches
conchie143312683co_n_chie
concho134414263co_n_cho
conchs134714903co_n_chs
conchy163710223co_n_chy
concise11314473co_ncise
conic95329793co_nic__
conical11316203co_nical
conics103920593co_nic_s
coniine9316803co_niine
conine84528553co_ni_ne
connive1238993conni_ve
coppice1537483coppic_e
coprince1447093coprinc_e
coracle112011723cor_acle
corbie103618203corbi__e
cordite10315263cordi_te
corncake1645263corncake
corncob1345663corn_cob
cornichons1743163cornichons
cornicing1439043cornicing
cornier93017093corni_er
corniest102117303corniest
cornified1546623cornified
cornifies1439003cornifies
cornify1536253corni_fy
cornily12410853corni_ly
corning103720133corni_ng
cornpone1246933cornpone
cornute939643corn_ute
coronach1545763coronach_
coronachs1644253coronachs
corrie83621233corri__e
cortical12412213cortical
corticate13410773corticate
cortices12615023cortices
corticose1346053corticose
corvine122113643corvi_ne
creche13310763c_r_eche
cronish12310863cronish_
curlicue1243223curlicue
curricle12145933curricle
dormice1237133dormic_e
dornick1435273dornic_k
dornicks1544403dornicks
fornical1347793fornical
fornicate1446083fornicate
fornices1369103fornices
loricae938253lor_icae
mortice11711493mortic_e
niche105016793___niche
orache114013593_or_ache
ornithes1136423_ornithes
orrice81410163_orric_e
postiche1547793postiche
potiche1438043po_tiche
soroche1237183sor_oche
subniche1554253subniche
vernicle1346433vernicle

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 Filter1786911461620.436409841.7
2DLD Change Limit146162817.58019282.6
3Display Results81810.0302700.0
 (SQL Overall)178691818.04622208.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.