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

38 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
estaminet114969(None) 
estaminets1243981estaminets
etamine91313072e_tamine_
etamines101611812e_tamines
astatine8313533astatine_
astatines9310343astatines
destained1158253desta_ined
enamine91214313e_namine_
enamines101112133e_namines
estating92614993estatin_g
estuarine944983estuarine_
etamin81311853e_tamin__
etamins91511833e_tamin_s
examine161510033e_xamine_
examined18135863e_xamined
examinee17156583e_xaminee
examiner17145463e_xaminer
examines17128793e_xamines
histamine1476903histamine_
histamines1575893histamines
jessamine1892973jessamine_
jessamines19102813jessamines
ketamine14157053ketamine_
ketamines15177033ketamines
satinet7325283_s_atinet
stained84215343_sta_ined
stainer73614923_sta_iner
stamened1137633_stamened
stamina9310793_stamin_a
staminal1046983_staminal
staminas1048853_staminas
staminate1187983_staminate
stamineal1143103_stamineal
stanine73417073_stanine_
stanines85115673_stanines
testament1166953testamen_t
vitamine1347373vitamine_
vitamines1446553vitamines

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.436409841.7
2DLD Change Limit148641387.26620457.1
3Display Results38380.0132923.1
 (SQL Overall)178691387.71523161.5
 
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.