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

63 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
analcite104933(None) 
analcime1245391analcime
analcites1147481analcites
analcimes1344322analcimes
anality10313632anal_ity
analyte10158812anal_yte
calcite11413782_calcite
adamsite1144423adamsite
albite8313313__albite
allanite8411093allanite
anaclises1147863anaclises
anaclitic1346503anaclitic
analcimic1553013analcimic
analecta1045733analecta
analectic1347233analectic
analects1047703analects
analgia898363analgi_a
analgias9107803analgias
analities9715873anal_ities
analogize19156543analogize
analogue9136253analogue
analyse10208893anal_yse
analyst10189323analyst_
analysts11167443analysts
analytes11169203anal_ytes
analytic1348183analytic
analyze19167013anal_yze
andalusite1152823andalusite
andesite949453andesite
anglesite1045753anglesite
anglice1089213angl_ice
anglicise1254503anglicise
anglicize2144243anglicize
aniline7418473anil_ine
anility10312723anil_ity
ankerite1248923ankerite
anlace82513923anlac__e
anolyte10159003anol_yte
anticity13313603anticity
antlike11312073antl_ike
apatite9312963apa_tite
aplite8316393a_pl_ite
banality1338763banal_ity
banalize191010933banal_ize
calcine11315273_calcine
calcites12313003_calcites
canalise10816213canal_ise
canalize19914493canal_ize
carnallite1244123carnallite
dacite91115883_da_cite
egalite8311563egal_ite
falcate12311613_falcate
fayalite1447053fayal_ite
gnathite1244483gnathite
halite93624233_hal_ite
hyalite13229473hyal_ite
incite83618733in__cite
kamacite1645293kama_cite
smaltite1046903smaltite
tantalite91010863tantal_ite
unakite1138743una_kite
unalike11311533unal_ike
uralite71714103ural_ite

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.436409841.7
2DLD Change Limit146162636.76621602.4
3Display Results63630.0302100.0
 (SQL Overall)178691637.23224708.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.