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

42 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
asphalts134418(None) 
asphalt1248081asphalt_
asphalted1543112asphalted
asphaltic1644602asphaltic
asphaltum1651382asphaltum
asphaltums1751092asphaltums
alphabets1652593alphabets
alphas1139513alpha__s
alphyls15113953alphyl_s
appalls11337743a_ppalls
appals104812943a_ppal_s
appeals11378673appeal_s
arhats9312973a_rha_ts
ashfalls1443433ashfalls
ashlars10297063as_hlars
ashplants1443533ashplants
aspects1146743asp_ects
asphalting1643383asphalting
asphaltite1552693asphaltite
asphaltites1652453asphaltites
aspirants1145233aspirants
assaults843863assaults
assholes1146743assholes
astrals75515243astral_s
basalts9358963bas__alts
eschalots1444133eschalots
espials937093espial_s
halts85230103___halts
omphalos1543693omphalos
paschals1566473paschal_s
salts55431883_s__alts
shafts125411443_s_hafts
shales94731253_s_hales
shalt85534493_s_halt_
smalts85214893_s_malts
spaits85017473_sp_aits
spales84728103_sp_ales
spalls84217343_sp_alls
spats75031383_sp_a_ts
spelts84614643_sp_elts
splats84817303_spla_ts
sprats85819933_spra_ts

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.453394461.4
2DLD Change Limit146162427.12320519.7
3Display Results42420.0162625.0
 (SQL Overall)178691427.59223536.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.