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

52 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
abstractest155362(None) 
abstracted1544842abstracte_d
abstracter1444692abstracte_r
abstracters1544102abstracters
abstractness1683012abstractness
abstracts1346592abstract_s_
abstract1249223abstrac___t
abstractedly2061773abstractedly
abstracting1645183abstracting
abstraction1545883abstraction
abstractive1854893abstractive
abstractly17123393abstract_ly
abstractor1444383abstract_or
abstractors1554413abstractors
abstricted1544093abstricte_d
abstricts1355183abstrict_s_
abstrusest1253173abstr_usest
straitest949173__straitest
strictest1147293__strictest
abruptest1342744ab__ruptest
absolutest1252764abs_olutest
abstractable1852194abstractable
abstractedness1962574abstractedness
abstractionist18133864abstractionist
abstractions1645784abstractions
abstractnesses1862294abstractnesses
abstrict1257944abstric___t
abstricting1654504abstricting
absurdest12143914absur__dest
arbitrates12117014arbitra_tes_
astricted1247444a_stricte_d
astricts1049464a_strict_s_
astrocytes1565974a_strocytes_
attractant1254154a_ttractant
attracted1246074a_ttracte_d
attracter1146094a_ttracte_r
attracters1245114a_ttracters
attracts1047794a_ttract_s_
australes9317764austra_les_
castrates11312674castra_tes_
distinctest1454974distinctest
distracted1448874distracte_d
distracts1249284distract_s_
lustrates939464lustra_tes_
mistraces13312294mistrac_es_
obstacles1343714obst_acles_
obstructed1544234obstructe_d
obstructs1344574obstruct_s_
stactes91914634__st_actes_
strangest103210844__strangest
strawiest1237214__strawiest
substrates12168554substra_tes_

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.1731032896.0
2DLD Change Limit148819529.54615589.7
3Display Results52520.0331575.8
 (SQL Overall)178691529.75218323.5
 
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.