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

310 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
appreciations196475(None) 
appreciation1855281appreciation_
appreciating1954082appreciati_ng
appreciators1853512appreciat_ors
depreciations1846572depreciations
unappreciations2181632unappreciations
abbreviations202145023abbreviations
appellations1643533app_ellations
apperceptions1893033apperceptions
applications1846773applic_ations
appreciates1754723appreciat__es
appreciative2153943appreciati_ve
appreciator1754113appreciat_o_r
appreciatory2153193appreciat_ory
approbations1854243appr_obations
appropriations1763173appropriations
approximations2761963approximations
deprecations1748563deprec_ations
depreciation1747073depreciation_
imprecations1846273imprec_ations
speciations1548483_sp_eciations
unappreciation2061963unappreciation_
abbreviation191175264abbreviation_
accreditations19122624accreditations
affectations2043434a_ffectations
aggregations1553844aggre_gations
alleviations1554494a_lleviations
altercations1446374alterc_ations
annunciations1572654annunciations
apparitions1544074app_ari_tions
appellation1564124app_ellation_
apperception1793464apperception_
application1747474applic_ation_
appositions1546154app_osi_tions
appreciate1655224appreciat___e
appreciated1854204appreciat__ed
appreciatively2672304appreciatively
apprehensions20102464apprehensions
approbation1755024appr_obation_
appropriation1653824appropriation_
approximation2652234approximation_
arcuations1249344a__r_cuations
asphyxiations2861334asphyxiations
associations1445754a_ssociations
brecciations1844284__brecciations
deprecation1648964deprec_ation_
depreciating1845034depreciati_ng
depreciators1753904depreciat_ors
depredations1646734depre_dations
excruciations24112994excruciations
expectations2365844exp_ectations
imprecation1746544imprec_ation_
imprecisions1853924impreci_sions
impregnations1853774impregnations
perennations1447254_perennations
precautions1546554__precautions
precisions1449374__preci_sions
predations13812154__pre_dations
predications17411184__predications
predictions1649654__predictions
prelibations16127624__prelibations
recitations13314204___recitations
speciation1449394_sp_eciation_
abbreviating2051565abbreviati_ng
abbreviators1971575abbreviat_ors
abdications1657655a_bdic_ations
aberrations1346695a__berrations
abjections2145675a_bjec__tions
abnegations1444925a_bne_gations
abreactions1544195a_bre_actions
abrogations14116465a_br_ogations
acceptations1864505a_cceptations
accreditation18112875accreditation_
accretions1444925accre___tions
adjudications2452325adjudications
adorations11310235ador___ations
advections1645555a_dvec__tions
advocations1755415a_dvoc_ations
aerations9317905a___e_rations
affectation1943845a_ffectation_
affections1845895a_ffec__tions
affiliations1844185a_ffiliations
afforestations2062245afforestations
aggradations1552705aggr_adations
aggravations1752435aggr_avations
aggregation1454255aggre_gation_
alienations1147885a_lie_nations
alimentations1594995alimentations
allegations1246045a_lle_gations
alleviation1454655a_lleviation_
allocations1347775a_lloc_ations
alterations11511665a_lte_rations
altercation1347015alterc_ation_
alternations1246775a_lternations
ammoniations1645415a_mmoniations
amortizations2456465amortizations
amplifications2384755amplifications
amputations1546445amp__utations
anglicizations26123335anglicizations
annexations1844265a_nne_xations
annunciation1462895annunciation_
anticipations1757495a_nticipations
apparition1444585app_ari_tion_
appellatives1952045app_ellatives
appertains1455275app_erta_i_ns
applicators1744255applic_at_ors
apportions1446285app___ortions
apposition1446595app_osi_tion_
appreciable1953845apprecia__ble
appreciably2253045apprecia__bly
apprehension1992645apprehension_
apprentices1753565appre__ntices
approbating1844585appr_obati_ng
appropriating1783495appropriati_ng
appropriators1663375appropriat_ors
approximating2761805approximati_ng
arabicizations2753905arabicizations
arcuation11410585a__r_cuation_
arrogations12126485a__rrogations
ascriptions1544985ascr__iptions
asphyxiation2761385asphyxiation_
aspirations1348995asp__irations
assentations1245835a_ssentations
association1346155a_ssociation_
attenuations1243805a_ttenuations
attestations1244465a_ttestations
attractions1376405attrac__tions
attritions1066795attr__i_tions
augmentations1654125augmentations
aviations12311555a____viations
avocations15168685a__voc_ations
brachiations19193525__brachiations
brecciation1744775__brecciation_
capacitations1953625cap_acitations
caprifications2385565caprifications
cerebrations1646965_cerebrations
coarctations16114495coar_ctations
consecrations1749215consecrations
consociations1747515consociations
corrections1548865correc__tions
correlations1447865corre_lations
creations112614545__cre__ations
cremations14410715__cre_mations
crenations12511695__cre_nations
crepitations1647475__crepitations
cupellations1643805cup_ellations
decimations16410165___decimations
decrepitations1984345decrepitations
defecations1779005_defec_ations
deglaciations1753915deglaciations
delectations1547455_delectations
denunciations1653885denunciations
depravations1885375depr_avations
deprecating1777285deprec_ati_ng
depreciates1664625depreciat__es
depreciative2084085depreciati_ve
depreciator1654265depreciat_o_r
depreciatory2063415depreciat_ory
depredation1546925depre_dation_
deprivations1897925depr_ivations
deracinations1647835_deracinations
derelictions1544335_derelictions
desecrations1559215_desecrations
deviations14311165___deviations
directions1379645_direc__tions
disrelations1348505disre_lations
dissociations1656015dissociations
duplications1746285duplic_ations
emaciations1548165__emaciations
embrocations1843985embroc_ations
enunciations1445095_enunciations
erections112515215__erec__tions
eructations1347235__eructations
excruciation23123315excruciation_
execrations2048925__execrations
exercitations2254565exer_citations
expatiations2146135exp_atiations
expatriations2253765expatriations
expectation2266485exp_ectation_
expeditions2144635exp_edi_tions
expiations1959665exp___iations
explications2347535explic_ations
expropriations2553325expropriations
extrications2149055extric_ations
fabrications1945925fabric_ations
fasciations1646265__fasciations
floriations1476915flor__iations
forestations1546325_forestations
fornications1755395_fornications
furcations1547535_fur_c_ations
glaciations1445965__glaciations
herniations1447405_her_niations
hyphenations2393525hyphe_nations
imbrications1845685imbric_ations
impetrations1645445imp_etrations
implications1847025implic_ations
imprecating1844905imprec_ati_ng
imprecision1753905impreci_sion_
impregnation1754015impregnation_
improvisations2152535improvisations
inappreciative2361705inappreciati_ve
ingratiations1455155ingratiations
irradiations1394885_irradiations
laureations1145575laure__ations
lubrications1645735lubric_ations
mediations13310985___mediations
metrications1649835metric_ations
officiations2053505_officiations
operations12312955_op_e_rations
oppositions1575125opp_osi_tions
oppressions1545725oppre__ssions
pacifications2267355pacifications
palletizations25105015palletizations
palliations1347725__palliations
participations2054535participations
partitions1248325_par_ti_tions
patronizations2576195patronizations
pectinations1649255__p_ectinations
peculations15310285__p_eculations
peltations12311555__p_eltations
penetrations1448855_penetrations
perceptions1798195_per_ceptions
percolations1648055_percolations
perditions1348875_per_di_tions
peregrinations17114685_peregrinations
perennation1348085_perennation_
perfections1848145_perfec__tions
perforations1747875_perforations
permeations1549885_per_meations
permutations1646505_permutations
perorations13314065_per_orations
perpetrations1746375_perpetrations
perpetuations1754985_perpetuations
persecutions1654795_persec_utions
personations1448395_personations
perspirations1786175_perspirations
petitions11511085__p_eti_tions
placations1438585__plac_ations
plications14310495__plic_ations
potentiations1555185_potentiations
precarious1445505__prec_arious
precaution1447245__precaution_
precessions1548555__precessions
precipitations2085395__precipitations
precipitins1746175__precipitins
precipitous1753925__precipitous
precisians1446415__preci_sians
precision13410055__preci_sion_
preclusions1544665__preclusions
predation12313465__pre_dation_
predication16412435__predication_
prediction15410305__prediction_
preemptions17134855__preemptions
prefixions2243875__prefi_xions
prelections151210475__prelections
prelibation15128665__prelibation_
prenotions1248295__pre_notions
preoptions1447645__pre_options
preparations1648315__preparations
preportions1548265__preportions
prescriptions19135335__prescriptions
preventions1648535__preventions
previsions1547735__previ_sions
privations15310105__pr_ivations
probations14311085__pr_obations
procreations1647275__procreations
procurations1647405__procurations
pronations12314035__pr_onations
prorations12314465__pr_orations
publications1845835_publications
punctations1585355__punctations
purgations1346745_pur__gations
purifications2047465_purifications
radiations11311925___radiations
reapplications2054255reapplic_ations
recautions1247815___recautions
receptions1449745___receptions
recisions1139915___reci_sions
recitation12315945___recitation_
recreations13412255___recreations
reflations13311235___reflations
relations92418335___re_lations
relictions12310025___relictions
remediations1548275_remediations
renunciations1554855renunciations
repatriations15136515repatriations
repetitions1378025rep_eti_tions
replications16811055replic_ations
reprobations1647775repr_obations
repudiations1597035rep_udiations
reradiations1349495_reradiations
restations10315845___restations
rubrications1646265rubric_ations
segregations1445805segre_gations
seriations10316685___seriations
speciating1548125_sp_eciati_ng
speciational1654315_sp_eciational
speculations1646395_sp_eculations
spoliations1347695_sp_oliations
sporulations1445685spor_ulations
striations10312795_str__iations
supernations14410875sup_ernations
superstations15208145superstations
supplications1954915supplic_ations
trepidations1554935__trepidations
typifications2344635typifications
unappreciative2381605unappreciati_ve
urtications1348035__urtications
vaporizations2776965vapor_izations
variations13310775_var__iations

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.423422437.4
2DLD Change Limit1247903108.65614416.6
3Display Results3103100.2031527.1
 (SQL Overall)1786913109.28219251.3
 
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.