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

87 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
vitamine134737(None) 
vitamin1237421vitamin_
vitamines1446551vitamines
vitamins1347081vitamins
diamine10311982di_amine
etamine91313072_etamine
histamine1476902histamine
ketamine14157052ketamine
vitalise11310742vitalise
vitalize20310502vitalize
vitaminic1642222vitaminic
vitrine102511362vit_rine
vituline1147092vituline
amine75835383___amine
antimine10714753antimine
astatine8313533astatine
betaine9413783beta_ine
calamine12314033calamine
catamite12510593catamite
citrine92514023cit_rine
diamide1138473di_amide
diamin9312523di_amin_
diamines11311643di_amines
diamins10312213di_amins
diazine1738933di_azine
dopamine1346173dopamine
enamine91214313_enamine
estaminet1149693estaminet
etamin81311853_etamin_
etamines101611813_etamines
etamins91511833_etamins
examine161510033_examine
famine114318193__famine
gamine94620153__gamine
glutamine1243573glutamine
hexamine2046873hexamine
histamin1387043histamin_
histamines1575893histamines
histamins1476723histamins
imagine1037883_imagine
imine75821063_i__mine
indamine1148433indamine
isatine7311763_isatine
iteming1037753_iteming
itemise997453_itemise
itemize18106153_itemize
ketamines15177033ketamines
limacine1246003limacine
melamine12310303melamine
petaline10314883petaline
protamine131310913protamine
putamina1244543putamina
simazine1945363simazine
stamina9310793_stamina
stanine73417073_stanine
sycamine1545723sycamine
taming94023433__taming
thiamine1346773thiamine
titanite898433titanite
titmice1144663tit_mice
tyramine1347303tyramine
vahine123612113v__ahine
valine94623093v__aline
velamina1345663velamina
vialing113614163vi_aling
victimise1674133victimise
victimize2544083victimize
vimina11339943vi__mina
viperine13189713viperine
visaing11279333visa_ing
vitae84217633vita___e
vitalised1347203vitalised
vitalises12310093vitalises
vitalism1339683vitalism
vitalist11313393vitalist
vitality1458113vitality
vitalized2239113vitalized
vitalizer2147303vitalizer
vitalizes2139923vitalizes
vitamer1235473vitam_er
vitamers1334683vitamers
vitelline1285853vitelline
vitiating1338403vitiating
vitrain1038943vitrain_
vitrains1138283vitrains
vitrines112610913vit_rines
vittling1236143vittling

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 Filter1786911461620.420425454.8
2DLD Change Limit146162876.62622058.9
3Display Results87870.0332636.4
 (SQL Overall)178691877.07925242.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.