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 “sardonic” 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
sardonic114745(None) 
baryonic1546202baryonic
carbonic1439992carbonic
hadronic1447952hadronic
harmonic1589432harmonic
parsonic1239702parsonic
sardonyx1941452sardonyx
sermonic1248882sermonic
acronic112814693_acronic
adonis7314063_a_donis
aeonic83517043_a_eonic
agonic93515143_a_gonic
ammonic1349163_ammonic
anionic9312873_anionic
aphonic142713393_aphonic
argotic10310273_argotic
arkosic1346053_arkosic
armonica1276863_armonica
arsenic939323_arsenic
atonic83420473_a_tonic
avionic1237693_avionic
axonic154312723_a_xonic
azonic175513153_a_zonic
bardic11312923bard__ic
boronic11311163bor_onic
canonic11312933ca_nonic
carbolic1448323carbolic
carditic1348683carditic
cardon94120853cardon__
cardons104519933cardon_s
cationic12310013cationic
chronic14311413chr_onic
cratonic1239113cratonic
cryonic1437833_cryonic
daemonic1356913daemonic
daimonic1346603daimonic
daltonic1146513daltonic
draconic1346193draconic
gardenia1045383gardenia
harmonica16105753harmonica
harmonics16107403harmonics
hedonic1339043_hedonic
hormonic1568153hormonic
hydronic1748093hydronic
ironic8313773_ir_onic
kaonic1238763ka__onic
laconic1139883la_conic
lactonic1248043lactonic
lardon74415063lardon__
lardons83914493lardon_s
lordotic1144983lordotic
masonic1139913ma_sonic
moronic11311863mor_onic
narcotic1277903narcotic
padroni10278613padroni_
paranoic1249833paranoic
pardon94618733pardon__
pardoned12189333pardoned
pardoner11189443pardoner
pardoning1338763pardoning
pardons103817623pardon_s
parodic122311723par_odic
parotic112518033par_otic
pharaonic1645763pharaonic
salmonid1147633salmonid
santonica1145373santonica
santonin849693santonin
saponin9310253sa_ponin
saprobic1445263saprobic
sarcoid10310453sarco_id
sardana838643sardan_a
sardanas937813sardanas
sardine83317393sardin_e
sardined10268663sardined
sardines92815563sardines
sardining1137573sardining
sardonicism1651873sardonicism
sarong73914873sar_on_g
sarongs84511803sar_ongs
sartorii845573sartorii
satanic939933sa_tanic
siphonic1547983siphonic
sonic75225283s___onic
sordini8228953sordini_
stolonic1047583stolonic
strobic1138243str_obic
strontic1048093str_ontic
subsonic1245753subsonic
subtonic1246913subtonic
sulfonic1344703sulfonic
syntonic1347693syntonic
tyronic1239313tyr_onic
zirconic2144013zirconic

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.1531167915.0
2DLD Change Limit146162938.58017035.2
3Display Results93930.0303100.0
 (SQL Overall)178691938.76320391.5
 
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.