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

49 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
tetanoid94720(None) 
melanoid1147122melanoid
petaloid1148752petaloid
retinoid947352retinoid
teratoid9411072teratoid
tetanic9810132tetan_ic
actinoid1148013actinoid
autacoid1146253autacoid
catenoid1149113catenoid
ceratoid1149923ceratoid
cretinoid1244363cretinoid
ctenoid1078683_ctenoid
demantoid1344623demantoid
ethmoid1345803_ethmoid
ganoid8314443__ganoid
hematoid1449753hematoid
humanoid1445713humanoid
keratoid1347273keratoid
lianoid837533_lianoid
melanoids1245553melanoids
metalloid1246203metalloid
metazoic2145433metazoic
paranoid11311143paranoid
pyranoid1447283pyranoid
resinoid946413resinoid
retinoids1045383retinoids
sepaloid1146763sepaloid
serranoid1045203serranoid
sesamoid1144063sesamoid
tabanid1047333taban_id
tenanted937043tenanted
terpenoid1244603terpenoid
tetanal738023tetan_al
tetanics10127373tetanics
tetanies8513553tetanies
tetanise8610203tetanise
tetanised1096513tetanised
tetanize17109953tetanize
tetanized1988443tetanized
tetanus737933tetan_us
tetany959843tetan__y
tetracid1147263tetracid
tetraploid1354213tetraploid
tetrapod1145123tetrapo_d
tetroxid1646443tetroxid
titania738293titan_ia
titanic968553titan_ic
titanous846553titanous
tretinoin943283tretinoin

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.423422437.4
2DLD Change Limit146162497.67019056.3
3Display Results49490.0163062.5
 (SQL Overall)178691498.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.