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

106 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
sarcoids113780(None) 
sarcoid10310451sarcoid_
aroids75118222_ar_oids
percoids1339662percoids
sarcomas1247222sarcomas
sarcous9312932sarco_us
sarods74918572sar_o_ds
sparoids11218712spar_oids
accords1247243_accords
acids87121003_a_c_ids
alcids94812293_alc_ids
aramids102810513_aramids
archils12510533_archils
arctics1138953_arctics
aroid65428343_ar_oid_
avoids104410203_a_voids
barmaids1345943barmaids
braconids1444193braconids
cancroids1444533cancroids
carabids1338193carabids
carcinoids1584453carcinoids
cardioids1345223cardioids
carloads1138393carloads
carotids11229943carotids
coccoids12176793coccoids
coracoids1445833coracoids
cricoids1347183cricoids
dacoits1079073da_coits
dermoids1246163dermoids
discoids1239873discoids
droids84712583_dr_oids
factoids1446243factoids
farcies125317883farc_ies
fucoids1335663_fucoids
gadoids1036873ga_doids
ganoids939333ga_noids
garboils1145663garboils
garcons102411643garco_ns
haloids113012553ha_loids
haploids1437363haploids
hyracoids1844253hyracoids
labroids1155843labroids
mastoids1177873mastoids
mattoids1196183mattoids
mucoids1237423_mucoids
narceins1036413narceins
narcomas1246043narcomas
narcos86714203narco__s
narcoses103910543narcoses
narcosis10388043narcosis
narcotics1374923narcotics
orchids1377213_orchids
paranoids1248913paranoids
parboils1237433parboils
parotids112610413parotids
parotoids1256953parotoids
percoid12312313percoid_
placoids1347343placoids
saids65328853sa___ids
saiyids11174893sa_iyids
salmonids1245543salmonids
salpids1038193sa_lpids
sapwoods1456263sapwoods
sarcasms1244983sarcasms
sarcina9310733sarc_ina
sarcinas1039273sarcinas
sarcoidoses1452543sarcoidoses
sarcoidosis1452153sarcoidosis
sarcoma1147403sarco_ma
sardius839553sar_dius
sards64736183sar___ds
sargos74318273sargo__s
sarins63932623sar__ins
saris54544953sar__i_s
sarod65325873sar_o_d_
sarode75317513sar_o_de
sarodes84216143sar_odes
sarodist9510923sar_odist
sarongs84511803sar_ongs
saros55238063sar_o__s
saroses73619333sar_oses
sartorius947163sartorius
sartors7314963sarto_rs
satyrids1245623satyrids
sautoirs834923sautoirs
sayids104310973sa__yids
sayyids14193833sa_yyids
scaphoids1744593scaphoids
scincoids1453413scincoids
scolds95011233s__colds
scrods94111603scr_o_ds
seconds1038283s_econds
shrouds1136023shr_ouds
sigmoids1244453sigmoids
sirloins836723sirloins
sloids73712693s__loids
sparids103512123spar__ids
sparoid102311543spar_oid_
steroids9911443steroids
strouds837803str_ouds
surcoats1047943surcoats
syrphids1744243syrphids
tabloids1146163tabloids
toroids8310643tor_oids
viroids1137923vir_oids
warlords1245303warlords

Search took 7 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 Limit1461621066.59322169.3
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.80926243.4
 
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.