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

106 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
appropriations176317(None) 
appropriation1653821appropriation_
appropriating1783492appropriati_ng
appropriators1663372appropriat_ors
expropriations2553322expropriations
appreciations1964753appr_eciations
approbations1854243appro__bations
appropriates1564063appropriat__es
appropriative1963023appropriati_ve
appropriator1563593appropriat_o_r
approximations2761963approximations
expropriation2453993expropriation_
apparitions1544074app__ari_tions
apportions1446284app_o_r__tions
appositions1546154app_o_si_tions
appreciation1855284appr_eciation_
approbation1755024appro__bation_
appropriate1464284appropriat___e
appropriated1663494appropriat__ed
appropriately1962654appropriat_ely
appropriateness1891584appropriateness
approximation2652234approximation_
expropriating2553244expropriati_ng
expropriators2462894expropriat_ors
perorations13314064_pero_r_ations
perspirations1786174_perspirations
procreations1647274__procreations
propagations1745554__propagations
propitiations1756204__propitiations
prorations12314464__pro_r_ations
reappropriating1991904reappropriati_ng
abbreviations202145025abbr_eviations
aberrations1346695aber__r_ations
abrogations14116465a_bro__gations
adorations11310235a__do_r_ations
ammoniations1645415a_mmo_niations
apparition1444585app__ari_tion_
appellations1643535app__ellations
applications1846775app__lications
apportion1347005app_o_r__tion_
apposition1446595app_o_si_tion_
appreciating1954085appr_eciati_ng
appreciators1853515appr_eciat_ors
approbating1844585appro__bati_ng
appropriable1762715appropria__ble
approximating2761805approximati_ng
arborizations2447425a__rborizations
arrogations12126485a_rro__gations
asphyxiations2861335asp_hyxiations
aspirations1348995asp__ir_ations
associations1445755a_sso_ciations
authorizations2655095autho_rizations
coproprietors1962435copropriet_ors
corporations16129485corpo_r_ations
depopulations1844495dep_opulations
deportations1548465dep_o_rtations
depreciations1846575depr_eciations
eutrophications2261715eutrophications
excoriations2147525_exco_riations
expatriations2253765exp_atriations
explorations2185615explo_r_ations
exportations2146655exp_o_rtations
expropriates23103405expropriat__es
expropriator2363015expropriat_o_r
floriations1476915__flo_riations
importations16156145imp_o_rtations
improprieties19142795improprieti_es
improvisations2152535improvisations
oppositions1575125opp_o_si_tions
parturitions1453785_parturi_tions
patronizations2576195patronizations
peregrinations17114685_peregrinations
perforations1747875_perfor_ations
peroration12316005_pero_r_ation_
perspiration1656835_perspiration_
perturbations17123265_perturbations
populations15148715__p_opulations
preparations1648315__preparations
probations14311085__pro__bations
procreation1547955__procreation_
procurations1647405__procurations
profanations17175255__profanations
pronations12314035__pro__nations
propagation1646445__propagation_
propitiation1656915__propitiation_
propitious1446605__prop_i_tious
proportions1548465__prop_ortions
propositions16108315__propositions
proprieties1556185__proprieti_es
proprietors1554385__propriet_ors
proration11415985__pro_r_ation_
prorogations1556725__prorogations
proscriptions19114165__proscriptions
prostrations1449765__prostrations
protonations1449075__protonations
protractions1646645__protractions
provocations1956875__provocations
reappropriates17102255reappropriat__es
repatriations15136515rep_atriations
repopulations1765335rep_opulations
reprobations1647775repro__bations
spoliations1347695_sp_o_liations
terrorizations2356175terro_rizations
unappreciations2181635unappr_eciations
unpropitious1662365unprop_i_tious
vaporizations2776965vap_o_rizations

Search took 6 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 Limit950241065.51617227.0
3Display Results1061060.0761394.7
 (SQL Overall)1786911065.95230022.0
 
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.