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

92 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
allanite841109(None) 
allanites949801allanites
alanine7316862a_lanine
almandite1245092almandite
alunite7311632a_lunite
aphanite1348772aphanite
melanite10512032melanite
ablate82219213abla__te
ablative1348243ablative
aconite9315473a_conite
alane56135613a_lan__e
alanin6317273a_lani_n
alanines8314803a_lanines
alanins7315803a_lanins
alant55742293a_lan_t_
alants67722023a_lan_ts
alate55340333a_la__te
albite8313313a_l_bite
alcaide1088453alca_ide
alginate9310693alginate
alienate8311553alienate
alkaline12168283alkaline
alkalise12178043alkalise
alkalize21177633alkalize
alkane104313323alkan__e
alkanet113714433alkanet_
alkanets12366233alkanets
allaying12339313allaying
alleviate1246063alleviate
alliance1097263allian_ce
allocate10411023allocate
allonge837023allon_ge
allspice1243343allspice
allusive1144783allusive
almandine1245393almandine
almandites1343953almandites
alunites8310703a_lunites
amanita9310453a_manita
ammonite1249143ammonite
analcite1049333analcite
andante8311273andan_te
apatite9312963a_patite
aphanites1448273aphanites
aplite8316393apl__ite
arenite71017713a_renite
arsenite8119663arsenite
aslant6317753aslan_t_
atlantes838553atlan_tes
autunite856693autunite
avianize2045723avianize
balkanize2444383balkanize
calamite12312533calamite
callant94121223callan_t_
callants104112143callan_ts
cyanite122710763_cyanite
fleabite1354163fleabite
galenite91210063galenite
gallamine1246123gallamine
gallant83517113gallan_t_
gallanted1145903gallan_ted
gallants93310373gallan_ts
gallate83417133galla__te
galvanise1344883galvanise
galvanize2245133galvanize
granite82017083_granite
illative1147183illative
illite63414923ill__ite
ilmenite1046223ilmenite
kaolinite1344043kaolinite
kyanite14237313_kyanite
lanate6421263__lanate
lenite6719983__lenite
lignite81310303_lignite
manganite1247783manganite
melanites11410733melanites
melanize19410303melanize
melinite10411753melinite
mylonite1346823mylonite
parlante1039693parlan_te
planate9314573_planate
rolamite1048743rolamite
selenite81713113selenite
slainte738543_slainte
solanine8311533solanine
sylvanite1543793sylvanite
tanzanite1844533tanzanite
titanite898433titanite
uranite72515693_uranite
urbanite1097183urbanite
vallate103016563valla__te
volante1038513volan_te
vulcanite1444713vulcanite

Search took 9 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.406440125.6
2DLD Change Limit146162927.68619016.7
3Display Results92920.0332787.9
 (SQL Overall)178691928.12521992.7
 
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.