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

93 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
ericoid104989(None) 
cricoid1239241cricoid
cricoids1347182cricoids
crinoid1039942crinoid
helicoid1446752helicoid
percoid12312312per_coid
trichoid1457812trichoid
arilloid946623arilloid
aroid65428343ar__oid
braconid1345633braconid
bricked164312063bricked
bricole112810493bricole
ceratoid1149923ceratoid
cirsoid1038123cirsoid
coccoid11299283coccoid
coracoid1348153coracoid
corticoid1445453corticoid
cricetid1345193cricetid
cricked164814283cricked
crinoids1147363crinoids
dermoid1138523der_moid
discoid11311243discoid
droid74218543dr__oid
echinoid1445993echinoid
elicit8417203elic_it
emeroid101511183emeroid
enriched1435863enriched
epizoic2045193epizoic
erected103213993erected
erica7316543eric__a
ericas8315463eric_as
eristic9814093eristic
eructed10228653eructed
ethmoid1345803ethmoid
euploid1038963euploid
evicted1337243evicted
frigid1136923fri_gid
fucoid1237893_fucoid
helicoids1544973helicoids
hyracoid1745973hyracoid
keratoid1347273keratoid
lipoid9411043_lipoid
medicaid1445783medicaid
meniscoid1443303meniscoid
mucoid1139783_mucoid
opioid9310083opi_oid
orchid1289573or_chid
peracid12312993perac_id
percoids1339663per_coids
pericope1447783pericope
pericopic1745543pericopic
period9314983peri_o_d
periodid1248163periodid
placoid1239773placoid
priced115018883pric_ed
pricked164613833pricked
prismoid1344983prismoid
quinoid1737353quinoid
recoil84016723_recoil
recoin84320293_recoin
record96117433_record
rerecord1145373rerecord
resinoid946413resinoid
retinoid947353retinoid
rhizoid2044583rhizoid
riced85825543_ric_ed
ricin74620213_ric_in
ricked136523623_ricked
rigid7913893_ri_gid
ripcord1264463_ripcord
sarcoid10310453sarcoid
scincoid1344753scincoid
sericin9312843seric_in
spiroid10219823spiroid
teratoid9411073teratoid
triacid1038593triacid
triced95518673tric_ed
tricked144016163tricked
trickie132611033trickie
triclad1037443triclad
tricorn937963tricorn
tricot8317753trico_t
tricots9311563tricots
trifid1039063tri_fid
trifold1136243trifold
trioxid1546613trioxid
triploid1147363triploid
tripod9399853tripo_d
trochoid1468443trochoid
viroid10411523_viroid
viscoid1337023viscoid
wricked174910193wricked
zincoid1946663zincoid

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 Filter1786911340270.420425454.8
2DLD Change Limit134027937.64317535.9
3Display Results93930.0462021.7
 (SQL Overall)178691938.10922036.1
 
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.