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

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

95 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
abstractnesses186229(None) 
abstractness1683012abstractne_s_s
abstrusenesses1552563abstrusenesses
straitnesses1246213__straitnesses
strictnesses1445413__strictnesses
abjectnesses2352564ab__jectnesses
abruptnesses1652614ab__ruptnesses
abstractedness1962574abstract_edness
abstracters1544104abstract_e__rs
abstractest1553624abstract_e_s_t
absurdnesses1562724absur__dnesses
arbitrarinesses1761424arbitrarinesses
distantnesses1453834dist_antnesses
distinctnesses1752564distinctnesses
instantnesses1354064inst_antnesses
instructresses1691754instructresses
intactnesses1444574_int_actnesses
abortivenesses1985295abortivenesses
abscesses1344105abs___c__esses
absolutenesses1662405absolutenesses
abstractable1852195abstract_able_
abstracted1544845abstract____ed
abstractedly2061775abstract_e_dly
abstracter1444695abstract____er
abstractionisms21132665abstractionisms
abstractionists19143305abstractionists
abstractions1645785abstract__ions
abstractive1854895abstract__ive_
abstractors1554415abstract___ors
abstracts1346595abstract_____s
abstruseness1452245abstrusene_s_s
accuratenesses1853085accuratenesses
adroitnesses1344135a__droitnesses
airtightnesses1851845airtightnesses
alertnesses1147235a_ler__tnesses
apartnesses1346825a___partnesses
apparentnesses18121775apparentnesses
archnesses1547175a___r_chnesses
assurednesses1352615assur_ednesses
astutenesses1245595a_st_utenesses
austerenesses1354175aust_erenesses
averagenesses1755015a_veragenesses
blacknesses1944995_b__lacknesses
brashnesses1646555_b__rashnesses
brattinesses1466265_b__rattinesses
bravenesses1647955_b__ravenesses
butchnesses1843705_but__chnesses
compactnesses2153005_compactnesses
contrarinesses1674245contrarinesses
correctnesses1754215_correctnesses
directnesses1595285__directnesses
discreetnesses1762435discreetnesses
erectnesses1347475___erectnesses
exactnesses2044345___exactnesses
gastightnesses19131825gastightnesses
habitualnesses1962215habitua_lnesses
ignorantnesses1562215ignorantnesses
indirectnesses1762165indirectnesses
inexactnesses2252915_inexactnesses
lustrousnesses1355755lustrousnesses
neutralnesses1354355neutra_lnesses
obduratenesses1752905obduratenesses
obstinatenesses1792625obstinatenesses
pastoralnesses1653135pastora_lnesses
racinesses12313515____racinesses
raptnesses1248525____raptnesses
saltnesses10310165__s__altnesses
scantnesses1376535__s_cantnesses
scarcenesses1644495__scarcenesses
selectnesses1446115__selectnesses
slacknesses1745245__s_lacknesses
smartnesses1337145__s_martnesses
spacinesses1538105__s_pacinesses
sprucenesses1694615__sprucenesses
squatnesses2045215__squa_tnesses
staginesses1238465__st_aginesses
staidnesses1237195__st_aidnesses
stalenesses11311105__st_alenesses
starchinesses1843215__starchinesses
starknesses1545885__st_arknesses
steadinesses1346905__steadinesses
steaminesses1446225__steaminesses
stoutnesses1146975__st_outnesses
straightnesses1872585__straightnesses
straitness1046295__straitne_s_s
strangenesses1454965__strangenesses
straplesses1353285__stra_plesses
streakinesses1743635__streakinesses
strictness1245645__strictne_s_s
swartnesses1436715__s_wartnesses
tacitnesses1336325___t_acitnesses
tartnesses101110715___t_artnesses
tautnesses10118285___t_autnesses
traitresses1144605___traitresses
unsteadinesses1553065unsteadinesses

Search took 8 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 Filter178691950240.1061685764.2
2DLD Change Limit95024957.17313247.5
3Display Results95950.0631507.9
 (SQL Overall)178691957.34224338.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.