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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
acceptingnesses2261511acceptingnesses_
acceptingness2061733acceptingne_s_s_
deceptivenesses23125895deceptivenesses_
fleetingnesses1872805_fleetingnesses_
receptivenesses22106055receptivenesses_
sweepingnesses2052065sweep_ingnesses_
activenesses1758216a_c__tivenesses_
adaptivenesses2054256a_daptivenesses_
adeptnesses1444836a_dept___nesses_
amusingnesses1652846a__musingnesses_
assertivenesses1754936assertivenesses_
attentivenesses1874696attentivenesses_
creativenesses1967036_creativenesses_
cunningnesses1673246__cunningnesses_
exactingnesses2452666_exactingnesses_
feelingnesses1753516__feelingnesses_
fittingnesses1773406__fittingnesses_
graspingnesses1852056grasp_ingnesses_
lastingnesses1444136__lastingnesses_
liltingnesses1453576__liltingnesses_
pleasingnesses1752836_pleasingnesses_
sterlingnesses1553146_sterlingnesses_
teemingnesses1653066__teemingnesses_
trustingnesses1582456_trustingnesses_
uncertainnesses1781356uncertain_nesses_
unfeelingnesses1971896unfeelingnesses_
abjectnesses2352567abject___nesses_
abortivenesses1985297a_bortivenesses_
abruptnesses1652617abrupt___nesses_
acceptableness2263267accept_able_ness
acceptances1653177accept__an__ces_
acceptees15113697accept____e__es_
accepting1695807accepting_______
acceptingly2152617accepting_____ly
accuratenesses1853087acc_uratenesses_
accursednesses1961777acc_ursednesses_
achinesses1539307a_c__hi__nesses_
acidnesses1337257a_c___i_dnesses_
acridnesses1445787a_c__ri_dnesses_
acutenesses13126977a_c_ut__enesses_
adaptednesses1772627a_dapt_ednesses_
adhesivenesses2155057adhe_sivenesses_
affectednesses2382607affect_ednesses_
alertnesses1147237a_lert___nesses_
aliennesses1145867alie___n_nesses_
amativenesses1856787a__mativenesses_
ancestresses1493277ancest___resses_
ancientnesses1553287anc__ientnesses_
apishnesses1646377a___p_ishnesses_
aptnesses11168997a___pt___nesses_
artinesses10815217a___rti__nesses_
aversivenesses2056567a_versivenesses_
belongingnesses1961457belongingnesses_
bindingnesses1753277__bindingnesses_
boringnesses15105027___boringnesses_
campinesses1737117_camp_i__nesses_
captiousnesses1886937__captiousnesses_
cattinesses13129707__catti__nesses_
chattinesses1755157_chatti__nesses_
cheekinesses2164207_cheeki__nesses_
cheerinesses1765827_cheeri__nesses_
cheesinesses1765377_cheesi__nesses_
chewinesses1945147_che_wi__nesses_
choppinesses2143357_choppi__nesses_
citizenesses2345677__c_itizenesses_
cleannesses13135827_cle__an_nesses_
coercivenesses2165657_coercivenesses_
coltishnesses1845227__coltishnesses_
confidingnesses2261817confidingnesses_
costivenesses1848167__costivenesses_
craftinesses1746387_crafti__nesses_
creakinesses1845997_creaki__nesses_
creaminesses1646137_creami__nesses_
creepinesses1645257_creepi__nesses_
crustinesses14137637_crusti__nesses_
cultishnesses1844567__cultishnesses_
daringnesses1464837___daringnesses_
darlingnesses1563047__darlingnesses_
deceitfulnesses2173047deceitfulnesses_
deceptiveness2155697deceptivene_s_s_
defectivenesses2496077defectivenesses_
demandingnesses2061747demandingnesses_
easygoingnesses20101077easygoingnesses_
effectivenesses2665107effectivenesses_
electivenesses1957647_electivenesses_
emptinesses1545997__empti__nesses_
enduringnesses1662497_enduringnesses_
entirenesses1249667___entirenesses_
essentialnesses1462647essentialnesses_
excessivenesses2675147excessivenesses_
facetiousnesses2055327face_tiousnesses_
fertilenesses1648037__fertilenesses_
festivenesses1998437__festivenesses_
fetidnesses1546657__fe_ti_dnesses_
fictivenesses2157127fic__tivenesses_
fleetingness1652657_fleetingne_s_s_
foreignnesses1752757fore__ignnesses_
forgivingnesses2371547forgivingnesses_
genuinenesses1475307__genuinenesses_
glaringnesses1553397__glaringnesses_
heftinesses1737137__hefti__nesses_
ineptnesses1396387_inept___nesses_
invectivenesses23106017invectivenesses_
inventivenesses21136257inventivenesses_
jettinesses1836387__jetti__nesses_
knowingnesses2152177__knowingnesses_
livingnesses1643667___livingnesses_
lovingnesses1643677___lovingnesses_
lucrativenesses2054377lucrativenesses_
meatinesses13311987__meati__nesses_
nothingnesses1752767__nothingnesses_
objectivenesses2994477objectivenesses_
obligingnesses1872017_obligingnesses_
ongoingnesses1583107__ongoingnesses_
outgoingnesses1661817_outgoingnesses_
peppinesses1435317__peppi__nesses_
petitenesses14169367__pe_titenesses_
pettinesses1338637__petti__nesses_
pettishnesses1844387__pettishnesses_
pinknesses1636587____p_inknesses_
preppinesses1544887_preppi__nesses_
prettinesses1447547_pretti__nesses_
recentnesses1465377rece___ntnesses_
receptiveness2056127receptivene_s_s_
recessivenesses1955817recessivenesses_
restivenesses1679447__restivenesses_
retentivenesses1896407retentivenesses_
retiringnesses1552487_retiringnesses_
scantinesses1437317_scanti__nesses_
scrappinesses1952297scrappi__nesses_
screwinesses1744747scre_wi__nesses_
secretivenesses2055687secretivenesses_
selectivenesses2056007selectivenesses_
sheepishnesses2153017sheep_ishnesses_
sleepinesses1445677sleep_i__nesses_
soothingnesses18102097_soothingnesses_
spininesses1358457___sp_ininesses_
springinesses16104067___springinesses_
stinginesses1375967____stinginesses_
supinenesses1446017__sup_inenesses_
sweatinesses1546917_sweati__nesses_
sweepingness1852207sweep_ingne_s_s_
tepidnesses1445387__tep_i_dnesses_
testinesses111210327__testi__nesses_
thingnesses1545197____thingnesses_
thinkingnesses2251897_thinkingnesses_
tininesses10311167_____tininesses_
unwillingnesses1961877unwillingnesses_
weepinesses1646137_weep_i__nesses_
willingnesses1753177__willingnesses_

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 Filter178691950240.360496363.9
2DLD Change Limit950241507.89012043.6
3Display Results1501500.1261190.5
 (SQL Overall)1786911508.37621333.7
 
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.