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 “aspen” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
aspen7521609(None) 
arpen74418041arpen
ashen87818671ashen
aspens85013351aspens
asper75520431asper
admen84516182admen
alien56425582alien
amen66733152a_men
amped104820512amped
ape57251182a_pe_
aped78538152a_ped
aper66336232a_per
apes66047432a_pes
apex137220212a_pex
appel94615892appel
append1138272append
apse67725382apse_
apses76823912apses
arpens84814822arpens
arpent84822092arpent
ascend9429732ascend
ascent84519652ascent
asea46327182as_ea
ashed97829772ashed
ashes86230612ashes
ashmen1168172ashmen
asked106919312asked
asker96418782asker
askew12529412askew
asp57235342asp__
aspect10612822aspect
aspers86220312aspers
aspic95114732aspic
aspis74618142aspis
asps65622092asp_s
assent65119952assent
asses55629282asses
asset55932262asset
aster55434892aster
astern64815812astern
auspex1574792auspex
axmen145112272axmen
copen94826432copen
dampen114310592dampen
fasten95114892fasten
gasmen93111562gasmen
gasped104814292gasped
gasper94515542gasper
happen134812192happen
hasped125014442hasped
hasten95718562hasten
jasper154610382jasper
mispen10312172mispen
open66427002_open
pen56558842__pen
rappen103512712rappen
rasped94715202rasped
rasper83917322rasper
ripen75619262ripen
seen46943122_seen
sen36058522_s_en
span65234662_span
spean74620512_spean
spec85821972_spec
sped76031492_sped
spend85619332_spend
spent75532832_spent
spew95421872_spew
spin66231302_spin
spun66221462_spun
unpen72913572unpen

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit53800711.90628226.7
3Display Results71710.0302366.7
 (SQL Overall)178691712.02988068.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.