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

79 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
vitamines144655(None) 
vitamine1347371vitamine_
vitamins1347081vitamin_s
diamines11311642di_amines
etamines101611812_etamines
histamines1575892histamines
ketamines15177032ketamines
vitalises12310092vitalises
vitalizes2139922vitalizes
vitamin1237422vitamin__
vitaminic1642222vitaminic
vitrines112610912vit_rines
amines84727983___amines
astatines9310343astatines
avitaminoses1771433avitaminoses
betaines10313293beta_ines
bigamies1337373bigami_es
calamines13312223calamines
catamites1349363catamites
citrines102513133cit_rines
diamides1238823di_amides
diamine10311983di_amine_
diamins10312213di_amin_s
diazines1838713di_azines
digamies1238643digami_es
dopamines1446043dopamines
enamines101112133_enamines
estaminet1149693estaminet
estaminets1243983estaminets
etamine91313073_etamine_
etamins91511833_etamin_s
examines17128793_examines
famines123216263__famines
flamines13311643_flamines
gamines103618463__gamines
glutamines1343503glutamines
hexamines2146203hexamines
histamine1476903histamine_
histamins1476723histamin_s
imagines1137463_imagines
imines84918353_i__mines
indamines1247553indamines
isatines8310663_isatines
itemises1087693_itemises
itemizes19106023_itemizes
ketamine14157053ketamine_
litanies8310993litani_es
melamines1339763melamines
protamines14149803protamines
simazines2044863simazines
staminas1048853_staminas
stanines85115673_stanines
sycamines1645523sycamines
tamises92715973__tamises
thiamines1446383thiamines
titanites997413titanites
tyramines1447213tyramines
vahines133410523v__ahines
valines104520213v__alines
victimises1774093victimises
victimizes2664033victimizes
vitalise11310743vitalise_
vitalised1347203vitalised
vitalisms1448513vitalisms
vitalists1239223vitalists
vitalities1349093vitalities
vitalize20310503vitalize_
vitalized2239113vitalized
vitalizer2147303vitalizer
vitalizers2244723vitalizers
vitalness1245413vita_lness
vitamer1235473vitam__er
vitamers1334683vitam_ers
vitellines1394733vitellines
vitrains1138283vitrain_s
vitrine102511363vit_rine_
vituline1147093vituline_
vivaries1439263vivari_es
votaries11312013votari_es

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.406440125.6
2DLD Change Limit148641796.64322375.6
3Display Results79790.0431837.2
 (SQL Overall)178691797.09225196.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.