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

64 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
aphanite134877(None) 
aphanites1448261aphanites
allanite8411092allanite
apatite9312962ap_atite
aphanitic1646012aphanitic
aconite9315473a_conite
alanine7316863a_lanine
allanites949803allanites
almandite1245093almandite
alunite7311633a_lunite
amanita9310453a_manita
ammonite1249143ammonite
andante8311273andan_te
apanage1036803ap_anage
apatites10311293ap_atites
aphagia13247663aphagi_a
aphagias14237343aphagias
aphasia122510873aphasi_a
aphasiac15286593aphasiac
aphasias132710433aphasias
aphasic142810063aphasi_c
aphasics15257233aphasics
apholate13410473apholate
aphonia122711883aphoni_a
aphonias132611143aphonias
aphonic142713393aphoni_c
aphonics15259523aphonics
aphorise1339983aphorise
aphorize2249043aphorize
aphrodite1545483aphrodite
aplite8316393ap__lite
appanage1344083appanage
appetite1258493appetite
apposite12410013apposite
arenite71017713a_renite
arsenite8119663arsenite
asphaltite1552693asphaltite
autunite856693autunite
avianize2045723avianize
cyanite122710763_cyanite
gahnite1135973gah_nite
granite82017083_granite
halite93624233__halite
ichnite1245983ich_nite
japanize2645283jap_anize
khanate1437073_khanate
kyanite14237313_kyanite
manganite1247783manganite
melanite10512023melanite
ophite11410563oph__ite
paganise1139663paganise
paganize2048633paganize
pantie84326473_p_antie
parakite14410423parakite
parasite10314843parasite
phenate12412193_phenate
phonate12411813_phonate
pinite8321243_p_inite
planate9314573_planate
saponite10410533sap_onite
tanzanite1844533tanzanite
titanite898433titanite
uranite72515693_uranite
urbanite1097183urbanite

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 Limit146162647.79618748.3
3Display Results64640.0302133.3
 (SQL Overall)178691648.23221706.9
 
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.