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

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

113 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
unappreciations218163(None) 
unappreciation2061961unappreciation_
appreciations1964752__appreciations
appreciation1855283__appreciation_
unappreciative2381603unappreciati_ve
appreciating1954084__appreciati_ng
appreciators1853514__appreciat_ors
depreciations1846574__depreciations
inappreciative2361704inappreciati_ve
unappreciated2062454unappreciat__ed
abbreviations202145025__abbreviations
appellations1643535__app_ellations
apperceptions1893035__apperceptions
applications1846775__applic_ations
appreciates1754725__appreciat__es
appreciative2153945__appreciati_ve
appreciator1754115__appreciat_o_r
appreciatory2153195__appreciat_ory
approbations1854245__appr_obations
appropriations1763175__appropriations
approximations2761965__approximations
deprecations1748565__deprec_ations
depreciation1747075__depreciation_
imprecations1846275__imprec_ations
reapplications2054255reapplic_ations
speciations1548485___sp_eciations
abbreviation191175266__abbreviation_
accreditations19122626__accreditations
affectations2043436__a_ffectations
aggregations1553846__aggre_gations
alleviations1554496__a_lleviations
altercations1446376__alterc_ations
annunciations1572656__annunciations
apparitions1544076__app_ari_tions
appellation1564126__app_ellation_
apperception1793466__apperception_
application1747476__applic_ation_
appositions1546156__app_osi_tions
appreciate1655226__appreciat___e
appreciated1854206__appreciat__ed
appreciatively2672306__appreciatively
apprehensions20102466__apprehensions
approbation1755026__appr_obation_
appropriation1653826__appropriation_
approximation2652236__approximation_
arcuations1249346__a__r_cuations
asphyxiations2861336__asphyxiations
associations1445756__a_ssociations
brecciations1844286____brecciations
capacitations1953626_ca_p_acitations
caprifications2385566_ca_prifications
coarctations16114496coa__r_ctations
deprecation1648966__deprec_ation_
depreciating1845036__depreciati_ng
depreciators1753906__depreciat_ors
depredations1646736__depre_dations
disapprobations2262656disappr_obations
emaciations1548166ema____ciations
enunciations1445096en___unciations
evaporations1744696evapor___ations
exasperations2253696exasp_e_rations
excruciations24112996__excruciations
expatriations2253766expatr__iations
expectations2365846__exp_ectations
fabrications1945926_fa_bric_ations
fasciations1646266_fa___sciations
glaciations1445966gla____ciations
imprecation1746546__imprec_ation_
imprecisions1853926__impreci_sions
impregnations1853776__impregnations
inappreciable21102646inapprecia__ble
inappreciably24112626inapprecia__bly
incapacitations2181696incap_acitations
incarcerations1853006in_carcerations
indirections1556186in_direc__tions
inebriations1456326in_ebr__iations
infuriations1547446in_fur__iations
ingratiations1455156in__gratiations
inspections1546426in_sp_ec__tions
inspirations1447306inspir___ations
insurrections15104136insurrec__tions
intermediations1894426intermediations
interpellations1774706interpellations
interpretations17134806interpre_tations
interrelations1457616interre_lations
laureations1145576_la_ure__ations
misapplications2363076misapplic_ations
narrations1038946_na__r__rations
naturalizations2455766_naturalizations
nazifications2745526_nazific_ations
perennations1447256___perennations
precautions1546556____precautions
precisions1449376____preci_sions
predations13812156____pre_dations
predications17411186____predications
predictions1649656____predictions
prelibations16127626____prelibations
reaggregations1762846reaggre_gations
reapplication1954726reapplic_ation_
reciprocations20203386reciproc_ations
recitations13314206_____recitations
repatriations15136516repatr__iations
speciation1449396___sp_eciation_
supplications1954916_supplic_ations
unappealing1652196unapp_e__ali_ng
unappetizing2651746unapp_eti_zi_ng
undecillions1592646un___decillions
unifications1748046un__ific_ations
unpretentious1561986un__pretentious
unpropitious1662366un__propi_tious
urtications1348036u____rtications
vaporizations2776966_vapor_izations
variations13310776_va__r__iations

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.1401276364.3
2DLD Change Limit950241138.25011518.1
3Display Results1131130.0761486.8
 (SQL Overall)1786911138.46621106.9
 
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.