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

48 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
coracoids144583(None) 
coracoid1348151coracoid_
coccoids12176792co_ccoids
corticoids1544182corticoids
cricoids1347182c_ricoids
hyracoids1844252hyracoids
autacoids1244773autacoids
braconids1444193_braconids
carabids1338193cara_bids
caracoles13310073caracoles
caracols12310413caraco_ls
carangids1344573carangids
cardioids1345223cardioids
ceratoid1149923ceratoid_
characids1745263charac_ids
chorioids1545683chor_ioids
choroids1438693chor__oids
coccids11277213co__ccids
coccoid11299283co_ccoid_
colloids11310173co_lloids
conchoids1766273conchoids
concords1358593co_ncords
conoids10813883co__noids
coracles121811163corac_les
coralloid1244623coralloid_
cordwoods16104773cordwoods
corkwoods1964453corkwoods
cormoid12310403cor_moid_
corncobs1444723cornco_bs
corncribs1542963corncribs
coronoid1148943coronoid_
corticoid1445453corticoid_
corvids1337683cor__vids
cricoid1239243c_ricoid_
crinoids1147363c_rinoids
curacies12311763curac_ies
curacoas1246033curaco_as
hyracoid1745973hyracoid_
monacids13137513monac_ids
nonacids11148263nonac_ids
orchids1377213_or_chids
paranoids1248913paranoids
peracids13310073perac_ids
percoids1339663per_coids
placoids1347343_placoids
sarcoids1137803sar_coids
toroids8310643tor__oids
voracious1445503voracious

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.423422437.4
2DLD Change Limit148641486.70322175.3
3Display Results48480.0163000.0
 (SQL Overall)178691487.14225019.7
 
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.