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

66 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
coracoid134815(None) 
coracoids1445831coracoids
ceratoid1149922ceratoid
coccoid11299282co_ccoid
coralloid1244622coralloid
cormoid12310402cor_moid
coronoid1148942coronoid
corticoid1445452corticoid
cricoid1239242c_ricoid
hyracoid1745972hyracoid
autacoid1146253autacoid
boracic1338723borac_ic
braconid1345633_braconid
cactoid12311033c__actoid
carabid12311333cara_bid
caracol11310423caraco_l
caracole12310363caracole
caracoled1445993caracoled
caracols12310413caracols
carangid1246423carangid
carangoid1344513carangoid
cardioid1247453cardioid
characid1646863charac_id
choreoid1447923chor_eoid
chorioid1448333chor_ioid
choroid13311803chor__oid
cirsoid1038123cir_soid
coached153313843co_ached
coacted123611613co_acted
coccid102910743co__ccid
coccoids12176793co_ccoids
colloid10312883co_lloid
conchoid1688043conchoid
concord12510343co_ncord
conoid9818883co__noid
coracle112011723corac_le
coracles121811163coracles
cordwood1565603cordwood
corkwood1885213corkwood
corncob1345663cornco_b
corncobs1444723corncobs
corncrib1443903corncrib
corticoids1544183corticoids
corvid12310473cor__vid
cotyloid1445493cotyloid
cracked163514743c_racked
cricoids1347183c_ricoids
crinoid1039943c_rinoid
curacoa1146223curaco_a
curacoas1246033curacoas
ericoid1049893_ericoid
hyracoids1844253hyracoids
keratoid1347273keratoid
monacid121310243monac_id
nonacid101210843nonac_id
orchid1289573_or_chid
paranoid11311143paranoid
peracid12312993perac_id
percoid12312313per_coid
placoid1239773_placoid
pyranoid1447283pyranoid
sarcoid10310453sar_coid
scaraboid1443753scaraboid
scorpioid1443293scorpioid
teratoid9411073teratoid
toroid7416013tor__oid

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 Filter1786911461620.436409841.7
2DLD Change Limit146162667.47019566.5
3Display Results66660.0135076.9
 (SQL Overall)178691667.91922564.8
 
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.