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

180 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
corniced136859(None) 
cornice11612931cornice_
cornices12713281cornices
cognised1256312cognised
cognized2136292cognized
connived1436432connived
coppiced1734822coppiced
corned95224522corn__ed
cornered11311132cornered
cornfed1337382corn_fed
corniche1575922corniche
corniches1666672corniches
cornicle1258782cornicle
cornicles1368242cornicles
cornier93017082corni_er
cornified1546622cornified
cornuted1137462cornuted
cortices12615002cortices
fornices1369102fornices
morticed1377162morticed
acorned10238263acorn__ed
bornite9311183bornite_
bornites10310973bornites
bounced123610553boun_ced
carices114220953car_ices
caried94528693car_i_ed
carnie84421093carni_e_
carnies94123963carni_es
carnified1547293carnified
carried103717153carri_ed
cervices1537133cervices
chaliced1637043chaliced
chanced154113213chan_ced
chronicled1842773chronicled
cirriped1344183cirriped
codices12512583co_dices
coedited1237823coedited
coenacted1445803coenacted
coerced1238583co_erced
coffined1735993coffined
cognise1059683cognise_
cognises11610043cognises
cognize1957683cognize_
cognizer2055863cognizer
cognizes2058023cognizes
coifed124113063co__ifed
coiled95123933co__iled
coincide1346493coincide
coincided1544023coincided
coined94523603co__ined
cojoined1856293cojoined
collided12309793collided
collied103316673colli_ed
colonised12248723colonised
colonized212710433colonized
combined15269183combined
commixed2264743commixed
compiled1537813compiled
concede12310093co_n_cede
conduced14136953conduced
coned86040053co_n__ed
confided1537453confided
confined14310403confined
congaed11399743co_ngaed
congeed113212313co_ngeed
conic95329793co_nic__
conical11316203co_nical
conics103920593co_nic_s
conies84338593co_ni_es
conifer123212643co_nifer
conine84528553co_nine_
conines93827793co_nines
conked135019113co_n_ked
connected1438753connected
conned95119703co_n_ned
connive1238993connive_
conniver1337493conniver
connives1339723connives
connoted1138863connoted
convicted1746313convicted
convinced1745363convinced
copied114618563co_pi_ed
coppice1537483coppice_
coppices1638243coppices
coprince1447093coprince_
coprinces1547483coprinces
corbeled1338373corbeled
corbie103618203corbi_e_
corbies113520113corbi_es
corded105923353cor__ded
cordite10315253cordite_
cordites11314603cordites
cordoned12229613cordoned
cored85044223cor___ed
corked135020783cor__ked
corkier133114303corki_er
cornbread1443063cornbread
corncob1345663corn_cob
cornea84018923corn__ea
cornel84020053corn__el
corner84625623corn__er
cornet84436733corn__et
cornfield1542853cornfield
cornichon1642883cornichon
cornicing1439033cornicing
corniest102117303corniest
cornifies1438993cornifies
cornify1536253corni_fy
cornily12410853corni_ly
corniness112611183corniness
corning103720123corni_ng
cornrowed1543623cornrowed
cornuses10310033cornuses
cornute939633cornute_
coronated123313323coronated
coroneted12278323coroneted
corraded12128293corraded
corrected1438113corrected
corrie83621213corri_e_
corries94026783corri_es
corroded12147513corroded
corseted11311473corseted
cortical12412203cortical
corticoid1445453corticoid
corvid12310473corvi__d
corvine122113643corvine_
corymbed1842613corymbed
cosied94819883co_si_ed
counted103815803coun_ted
cowhided1843743cowhided
cozied184112153co_zi_ed
creviced1634453creviced
cricked164814283c_r_icked
cried84624283c_r_i_ed
cringed113312403c_ringed
cronies9622503croni_es
cruised103710213c_ruised
curlicued1442133curlicued
curried103313653curri_ed
cyanided15254893cyanided
dormice1237133dormice_
dornick1435273dornic_k
dornicks1544403dornicks
forced126316523for__ced
fornical1347793fornical
fornicated1644823fornicated
furnaced1443513furnaced
honied104818393ho_ni_ed
horned105718703horn__ed
hornier103012453horni_er
ionised82911493io_nised
ionized172611293io_nized
ironized1858203ironized
jounced17337613joun_ced
monied94319463mo_ni_ed
mortice11711493mortice_
mortices12711553mortices
mortised1178743mortised
noticed1037863no_ticed
orbited1037733_orbited
orrice81410163_orrice_
orrices9129363_orrices
policed123212233po_liced
ponced114314813po_n_ced
ponied94920703po_ni_ed
pornier93413123porni_er
porticoed1445423porticoed
pounced123510623poun_ced
priced115018883_pr_iced
riced85825543__r_iced
sconced12359173sco_n_ced
scorned10229953scorn__ed
serviced1435613serviced
sorned74820043sorn__ed
sortied83314093sorti_ed
triced95518673_tr_iced
voiced123910113vo__iced
vortices1369123vortices
worried11308693worri_ed
worrited1235743worrited

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.1701051123.5
2DLD Change Limit1461621808.61016975.8
3Display Results1801800.1261428.6
 (SQL Overall)1786911808.90620064.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.