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

98 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
attrited94737(None) 
attrite7311831attrite_
attrites8311581attrites
attritted1044491attritted
astricted1247442astricted
attained997352attained
attainted1044692attainted
attested936312attested
attired8238912att_ired
attracted1246072attracted
attributed1352722attributed
attrit6315752attrit__
attrits7310632attrit_s
aborted10310423abor_ted
abstricted1544093abstricted
accreted1336353accreted
acerated113114003acerated
actuated1138753actuated
aerated85322383a_erated
aeried74221873a_eri_ed
airted74214503a_ir_ted
alerted82512233aler_ted
antired82316193ant_ired
apprised1337713apprised
apprized2236543apprized
ariled75620323a__riled
arrived11127353a_rrived
ascribed1374693ascribed
asteriated1178023asteriated
astride8311973astride_
astringed1145693astringed
atomised11278833atomised
atomized20279323atomized
attached14165703attached
attacked15125113attacked
attainer8116913attainer
attempted1442573attempted
attended1035763attended
attester836503attester
atticized2146143atticized
attire62412383att_ire_
attires72312953att_ires
attitude9196033att_itude
attorned955363attorned
attracter1146093attracter
attribute1153513attribute_
attributes1253363attributes
attriting1048693attriting
attrition966973attrition
attritive1246083attritive
attuned835173att_uned
audited939033a_udited
aurated83817793a_urated
averted112211623aver_ted
awaited1146963a_waited
azurite1638003azurite_
azurites1737293azurites
castrated1239523castrated
citrated112712253citrated
intuited938763intuited
iterated91213833iterated
laterite8716353laterite_
laterites9715083laterites
laterized1979933laterized
latticed1134793latt_iced
maturated1249173maturated
merited10313853_merited
nitrated92213153nitrated
nitrided10276753nitrided
nitrite72314463nitrite_
nitrites82313453nitrites
outrated92219323outrated
patriated1238543patriated
rattailed1084213rattailed
retried84419163retri_ed
satirised1046553satirised
satirized1957893satirized
saturated1039003saturated
spirited1148973spirited
started84217323star_ted
storied8515163stori_ed
striated93414153_striated
striped105214363_striped
strived114713663_strived
tarried83914133tarri_ed
tarted74923373_tar_ted
tartrated1096653tartrated
tatted74920533tat__ted
thrived14458183_thrived
titrated92611683titrated
toited74016753__toited
triced95518673__triced
tried65026913__tri_ed
trined74920713__trined
trite54730033__trite_
triter65120593__triter
untried82615853untri_ed
worrited1235743worrited

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 Limit146162987.73618893.7
3Display Results98980.0462130.4
 (SQL Overall)178691988.18821823.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.