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

58 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
actinoids124629(None) 
actinoid1148001actinoid_
actinias101810842actin_ias
actinide11199212actin_ide
actinides12188322actin_ides
actinons10389452actino_ns
catenoids1246422catenoids
crinoids1147352_crinoids
echinoids1544222echinoids
retinoids1045382retinoids
acinous9310923ac_ino_us
actings104512463actin__gs
actinia91710853actin_i_a
actiniae101810013actin_iae
actinian10209003actin_ian
actinians11167003actinians
actinic111810553actin_i_c
actinism12119883actin_ism
actinisms1398883actinisms
actinium1297553actin_ium
actiniums1395843actiniums
actinolite1255093actinolite
actinolites1354733actinolites
actinon9459463actino__n
actins86321103actin___s
actioners1147713actioners
actions94218513acti_o_ns
adenoids1056843a_denoids
ammonoids1493503ammonoids
antinode9810233antino_de
antinodes1099603antinodes
antinoise949733antinoise
antinomes11710143antinomes
antinomies1249363antinomies
arytenoids1452553arytenoids
asteroids1048723asteroids
autacoids1244763autacoids
autocoids1246093autocoids
bacteroids1545183bacteroids
carcinoids1584443carcinoids
carotinoids1452583carotinoids
catenoid1149113catenoid_
conoids10813883_c_onoids
cricoids1347183_cricoids
crinoid1039943_crinoid_
ctenoid1078683_ctenoid_
echinoid1445993echinoid_
factoids1446243fact__oids
hominoids1544683hominoids
nautiloids1152133nautiloids
platinoids1344003platinoids
quinoids1845683_quinoids
resinoids1044703resinoids
retinoid947353retinoid_
schizoids2443383schizoids
scincoids1453413sc_incoids
tachinids1544043tachin_ids
tineids8337873__tineids

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.1561145455.1
2DLD Change Limit148641587.04621095.8
3Display Results58580.0301933.3
 (SQL Overall)178691587.23224708.4
 
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.