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

69 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
ashlering134415(None) 
ashlaring1344491ashlaring
adhering1338882adh_ering
cashiering1643782cashiering
kashering1736252kash_ering
sheering123715102_sheering
ushering1258922ush_ering
abhorring1543543abhorring
achieving1843303achieving
alerting91312383a__lerting
alleging1038473a_lleging
alluring939073a_lluring
altering91917113a_ltering
angering102113803a_ngering
answering1345803answering
ashing107824093ash___ing
ashler9459973ashler___
ashlered1244623ashler_ed
ashlers10319583ashler__s
aspersing1237603as_persing
aspiring1138873as_piring
asserting1038663as_serting
assuring937773as_suring
atheling1249203ath_eling
cheering143612703_cheering
cohering142413833coh_ering
coshering15510023cosh_ering
fathering161010093fath_ering
fullering1336653fullering
gathering1499463gath_ering
hollering1337743hollering
inhering12913713inh_ering
koshering1735363kosh_ering
lathering13912253lath_ering
mastering122315303mas_tering
ochering14219393och_ering
sabering112113743_sabering
saggering12197793saggering
sering74731813_s__ering
severing122013853_severing
sewering122411093_sewering
sharing113723243_sh_aring
shearing123915903_shearing
sheening123010803_sheening
sheeting122712833_sheeting
shelling123515213_shelling
sheltering1446493_sheltering
shelving15278173_shelving
shewing143812193_sh_ewing
shieling123512403_shieling
shirring122910443_shirring
shivering1637333_shivering
shlepping1733393_shlepping
shoeing113211883_shoe_ing
shoring112820073_sh_oring
showering1646403_showering
showring1548323_showring
shrewing15228093_shrewing
silvering1337923_silvering
slewing113311353_s_lewing
sneering93414503_sneering
sobering111912783_sobering
soldering1169033_soldering
speering113116323_speering
sphering142811943_sphering
spiering112713353_spiering
steering93916793_steering
supering11317683_supering
tillering1037883tillering

Search took 7 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 Filter1786911486410.453394461.4
2DLD Change Limit148641696.18624028.6
3Display Results69690.0332090.9
 (SQL Overall)178691696.67226782.2
 
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.