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

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

44 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
abstentious136267(None) 
abstentions1364361abstentions
abstemious1452032abste_mious
abstention1254392abstentio_n
arsenious945223ars_en_ious
attentions1045983a_ttentions
contentious1347013contentious
dissentious12184473dissentious
distentions12178843distentions
pretentious13125593pretentious
sententious11104183sententious
abjections2145674ab_jections
absentees1164534abs_ent_ees
absenters1156174abs_ent_ers
absenting1236994abs_enti_ng
absents93510724abs_ent___s
absolutions1344714absolutions
absorptions1544594absorptions
abstemiously1962434abste_miously
abstractions1645784abstractions
argentous1045604a_rgent_ous
arsenous847534ars_en__ous
asbestous1143154a_sbest_ous
ascensions1244614a_scensions
assentors955654a_ssent_ors
assertions1046584a_ssertions
attention946104a_ttentio_n
austenites1044964austen_ites
autecious1145614a_ute_cious
contentions13412094contentions
detentions11148804_detentions
dissentions12168044dissentions
distensions12146274distensions
distention11158874distentio_n
intentions10411404_intentions
licentious1243844_licentious
mysterious1543904myste_rious
obsequious2151474obs_equious
ostentatious1252864_ostentatious
portentous1244424portent_ous
retentions101611114_retentions
stenokous1343404__stenokous
stentors839744__stent_ors
tendentious1252954tendentious

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819448.98316566.7
3Display Results44440.0162750.0
 (SQL Overall)178691449.42218965.3
 
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.