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

76 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
taconite104931(None) 
aconite9315471_aconite
taconites1148471taconites
aconites10314352_aconites
masonite1049682masonite
saponite10410532saponite
acolyte12157653_acolyte
aconitic1239533_aconitic
aconitum1243743_aconitum
agonise83112693_agonise
agonize172911403_agonize
alunite7311633_alunite
amazonite2044213amazonite
ammonite1249143ammonite
amosite9313163_amosite
aragonite1046463aragonite
arenite71017713_arenite
backbite1899173backbite
canonise10511093canonise
canonize1959833canonize
caponize2139113caponize
conine84528553__conine
conte76633203__con_te
cyclonite1645453cyclonite
dacite91115883dac__ite
dacoit9415453daco_it_
dacoits1079073daco_its
dacoity1366183daco_ity
dawsonite1342703dawsonite
diaconate1247193diaconate
ebonite9310293_ebonite
essonite845733essonite
falconine1445173falconine
favorite1447313favorite
gahnite1135973ga_hnite
galenite91210063galenite
glauconite13102613glauconite
ichnite1245983_ichnite
incondite1246553incondite
jaconet16311483jaconet_
jaconets1745613jaconets
jarosite1548383jarosite
kainite1149543ka_inite
laborite10410693laborite
laciniate1156843laciniate
laconic1139883laconi_c
laconism1248043laconism
lacunate10128963lacunate
limonite1048163limonite
mannite9312903ma_nnite
masonites1149173masonites
mylonite1346823mylonite
pavonine1346663pavonine
recondite1248963recondite
saponine1039223saponine
saponites1139943saponites
stannite847583sta_nnite
taborine102510683taborine
tachiste1356213tachiste
tachylite1744033tachylite
tacit76333673tac__it_
tacnode1045093tac_node
tacrine9311293tac_rine
tactile9310613tac_tile
taeniae739083ta_eniae
tannate71813523ta_nnate
tanzanite1844533tanzanite
taxite13511303ta__xite
tectite9310583tec_tite
tenorite8311993tenorite
thionate11137503thionate
thionine1187923thionine
thorite10313443t_horite
titanite898433titanite
toonie63617993t_ooni_e
twoonie1034423twooni_e

Search took 10 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.843211970.3
2DLD Change Limit146162768.45317291.1
3Display Results76760.0302533.3
 (SQL Overall)178691769.32619160.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.