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

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
appropriation165382(None) 
appropriations1763171appropriations
appropriating1783492appropriating
appropriative1963022appropriative
appropriator1563592appropriat_or
expropriation2453992expropriation
appreciation1855283appr_eciation
approbation1755023appro__bation
appropriate1464283appropriat__e
appropriated1663493appropriat_ed
appropriately1962653appropriately
appropriates1564063appropriat_es
appropriators1663373appropriators
approximation2652233approximation
expropriations2553323expropriations
apparition1444584app__ari_tion
apportion1347004app_o_r__tion
apposition1446594app_o_si_tion
appreciations1964754appr_eciations
approbations1854244appro__bations
appropriable1762714appropria_ble
approximations2761964approximations
expropriating2553244expropriating
expropriator2363014expropriat_or
peroration12316004_pero_r_ation
perspiration1656834_perspiration
procreation1547954__procreation
propagation1646444__propagation
propitiation1656914__propitiation
proration11415984__pro_r_ation
reappropriating1991904reappropriating
abbreviation191175265abbr_eviation
aberration1267205aber__r_ation
abrogation13107335a_bro__gation
adoration10311315a__do_r_ation
ammoniation1545905a_mmo_niation
apparitions1544075app__ari_tions
appellation1564125app__ellation
application1747475app__lication
apportions1446285app_o_r__tions
appositions1546155app_o_si_tions
appreciating1954085appr_eciating
appreciative2153945appr_eciative
appreciator1754115appr_eciat_or
approbating1844585appro__bating
appropriateness1891585appropriateness
approximating2761805approximating
approximative2961925approximative
arborization2347885a__rborization
arrogation11107445a_rro__gation
asphyxiation2761385asp_hyxiation
aspiration1249995asp__ir_ation
association1346155a_sso_ciation
authorization2555855autho_rization
coproprietor1862615copropriet_or
corporation151210655corpo_r_ation
depopulation1765065dep_opulation
deportation1449305dep_o_rtation
depreciation1747075depr_eciation
eutrophication2161925eutrophication
excoriation2048435_exco_riation
expatriation2154335exp_atriation
exploration2066715explo_r_ation
exportation2047445exp_o_rtation
expropriate2253785expropriat__e
expropriated2452995expropriat_ed
expropriates23103405expropriat_es
expropriators2462895expropriators
floriation1367795__flo_riation
importation15147125imp_o_rtation
improprieties19142795improprieties
improvisation2052995improvisation
inappropriate16112275inappropriat__e
inappropriately2171835inappropriately
opposition1445485opp_o_si_tion
parturition1354175_parturi_tion
patronization2456755patronization
peregrination16125205_peregrination
perforation1649005_perfor_ation
perorations13314065_pero_r_ations
perspirations1786175_perspirations
perturbation16123545_perturbation
population14810025__p_opulation
preparation1549275__preparation
probation13412185__pro__bation
procreations1647275__procreations
procuration1548295__procuration
profanation16186105__profanation
pronation11415705__pro__nation
propagations1745555__propagations
propitiations1756205__propitiations
proportion1448995__prop_ortion
proposition1588745__proposition
proprieties1556185__proprieties
proprietor1454485__propriet_or
prorations12314465__pro_r_ations
prorogation1447395__prorogation
proscription18124515__proscription
prostration13410795__prostration
protonation13510435__protonation
protraction1547215__protraction
provocation1847355__provocation
reappropriate1682425reappropriat__e
reappropriated1872105reappropriat_ed
reappropriates17102255reappropriat_es
repatriation14126975rep_atriation
repopulation1656105rep_opulation
reprobation1548505repro__bation
spoliation1248425_sp_o_liation
terrorization2256665terro_rization
unappreciation2061965unappr_eciation
unappropriated1872075unappropriat_ed
vaporization2697535vap_o_rization

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.390458182.1
2DLD Change Limit1247901138.69014360.2
3Display Results1131130.0761486.8
 (SQL Overall)1786911139.15619516.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.