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

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

103 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
practicalness195332(None) 
practicableness2362702practicableness
practicalnesses2162952practicalnesses
criticalness1653503cr_iticalness
poeticalness1653453p_oeticalness
practicals1645543practical___s
radicalness1454583_ra_dicalness
factualness1652994_fact_ualness
fanaticalness1862734fanaticalness
fractiousness1856874fractiousness
franticness1643604frantic__ness
grammaticalness2271304grammaticalness
identicalness1662664identicalness
ironicalness1463084ir_onicalness
palatialness1453244palati_alness
paradoxicalness2771564paradoxicalness
pastoralness1453604p_astoralness
physicalness2272694p_hysicalness
practicable1953834practicable__
practical1548844practical____
practicalities2053564practicalities
practicality2153594practical_ity
practically20410444practical__ly
practicers1663594practic___ers
practices1557994practic___e_s
practitioners1761574practitioners
rationalness1254464_ra_tionalness
tyrannicalness19111684tyrannicalness
verticalness1754214_verticalness
actionless1244155__actionl_ess
activeness1547705__acti_veness
artificialness1971405artificialness
beautifulness1853455beautifulness
brackishness2352455bracki_shness
bractless1335545bract___l_ess
brattiness1255845bratti___ness
craftiness1545755crafti___ness
criticalnesses1853155cr_iticalnesses
diabolicalness1971295diabolicalness
dogmaticalness2071515dogmaticalness
draftiness1444865drafti___ness
ethicalness1653365__ethicalness
exactingness2252125exacti_ngness
factiousness1787805_factiousness
fantasticalness2071745fantasticalness
fatalness1245775_fa_t__alness
finicalness1653615__finicalness
frailness1236555fra__i__lness
frictionless1752555frictionl_ess
gracefulness1855255grac_efulness
gracileness1444155grac_i_leness
graciousness1548435grac_iousness
gradualness1352855gra__dualness
graphicness1951625graphic__ness
gratefulness1655755gra_tefulness
graticules13104365gra_ticul_e_s
habitualness1751885_habitualness
illogicalness1662145illogicalness
initialness1155735_initi_alness
logicalness1453245__logicalness
lyricalness1653015__lyricalness
naturalness1153955_na_turalness
particles1339815p_artic_l_e_s
pastiness112312365p_asti___ness
patchiness1744935p_a_t_chiness
peacefulness1954995peac_efulness
pharisaicalness2291225pharisaicalness
pictorialness1762525p_ictorialness
pitifulness1665495p__itifulness
placidness1553305plac_i__dness
plasticenes15124285plastic_ene_s
plasticines15105435plastic_ine_s
plentifulness1893285plentifulness
poeticalnesses1853105p_oeticalnesses
practicably2254305practica__bly
practice1438735practic___e__
practiced1655115practic___e_d
practicer1544595practic___e_r
practicing1775585practic_in__g
practicums18132755practic___ums
practises1349625practi___se_s
practitioner1651895practitione_r
prankishness2153065pranki_shness
pratincoles1552485pra_tincol_e_s
prayerfulness2162695prayerfulness
preachiness1844285preachi___ness
preciousness1648475prec_iousness
preciseness1545785prec_i_seness
prejudicialness277945prejudicialness
prettiness1257395pretti___ness
priceless1336895pr___icel_ess
prickliness1943925pr___ickliness
raciness102413455_rac_i___ness
radicalises1445585_ra_dicalises
radicalnesses16124145_ra_dicalnesses
reactiveness1756925reacti_veness
specialness1554055spec_i_alness
tactfulness1645225_tact_fulness
tractableness1755035tractableness
triticales1246265tr_itical_e_s
typicalness1852575__typicalness
whimsicalness2361665whimsicalness
wrathfulness2154525wra_thfulness

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901038.59614517.2
3Display Results1031030.0631634.9
 (SQL Overall)1786911039.06519712.2
 
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.