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

55 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
indamines124755(None) 
indamine1148431indamine_
indamins1147601indamin_s
enamines101112132en_amines
indamin1048042indamin__
indulines1057762indulines
infamies1346682infami_es
amines84727983___amines
calamines13312223calamines
diamines11311643_diamines
domines102918973__domines
dopamines1446043dopamines
enamine91214313en_amine_
endamages1343773endamages
endexines1745203endexines
etamines101611813_etamines
examines17128793_examines
famines123216263__famines
flamines13311643_flamines
gamines103618463__gamines
hexamines2146203hexamines
histamines1575893histamines
illumines1145873illumines
imagines1137463i_magines
imines84918353i___mines
inanes62519803in_a__nes
inclines10313143in_clines
incomings1445213incomings
indagates1146573indagates
indenes82916253ind__enes
indexings1843693indexings
indices103513443ind__ices
indies73822783ind__i_es
indigenes11228993indigenes
indites83618983ind__ites
induline939493induline_
indulins958863indulin_s
inosines8312703in_osines
inshrines1246533inshrines
intines7921113in__tines
intwines1138043in_twines
iodines83616633iod__ines
isatines8310663i_satines
ketamines15177033ketamines
lindanes939173linda__nes
melamines1339763melamines
monoamines1446853monoamines
rhodamines1643883rhodamines
sodamides1344653sodamides
sycamines1645523sycamines
thiamines1446383thiamines
tyramines1447213tyramines
undermines131710663undermines
undines8716083und__ines
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.423422437.4
2DLD Change Limit148641556.90621523.5
3Display Results55550.0301833.3
 (SQL Overall)178691557.35924282.0
 
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.