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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
approximations276196(None) 
approximation2652231approximation_
approximating2761802approximati_ng
appreciations1964753appreci_ations
approbations1854243appro__bations
appropriations1763173appropriations
approximates25112643approximat__es
approximative2961923approximati_ve
applications1846774app__lications
appositions1546154app_osi__tions
appreciation1855284appreci_ation_
approbation1755024appro__bation_
appropriation1653824appropriation_
approximate24132884approximat___e
approximated26142404approximat__ed
approximately2981574approximat_ely
asphyxiations2861334asphyxi_ations
autoxidations2153554a_utoxidations
epoxidations2243644_ep_oxidations
improvisations2152534improvisations
patronizations2576194patronizations
abbreviations202145025abbrevi_ations
abominations1646615a__bominations
abrogations14116465a_bro__gations
acclimations18146295a__cclimations
accreditations19122625accreditations
aldolizations2346345a_ldolizations
ammoniations1645415a_mmoni_ations
amortizations2456465amor_tizations
amplifications2384755amplifications
animations12312195a____nimations
anodizations2276925a__nodizations
apparitions1544075app_ari__tions
appellations1643535app__ellations
application1747475app__lication_
apportions1446285app_o___rtions
apposition1446595app_osi__tion_
appreciating1954085appreci_ati_ng
appreciators1853515appreci_at_ors
approbating1844585appro__bati_ng
appropriating1783495appropriati_ng
appropriators1663375appropriat_ors
arborizations2447425a_rborizations
arrogations12126485a_rro__gations
asphyxiation2761385asphyxi_ation_
aspirations1348995asp___irations
associations1445755a_ssoci_ations
atomizations2348475a__tomizations
authorizations2655095authorizations
automations1348235a_uto__mations
autoxidation2053785a_utoxidation_
brominations1646745__brominations
caprifications2385565caprifications
deoxidations2145245__deoxidations
depreciations1846575depreci_ations
deprivations1897925depr__ivations
detoxications2355655_detoxications
epoxidation2144065_ep_oxidation_
erotizations21411005__erotizations
exploitations2254215explo_itations
expropriations2553325expropriations
hydroxylations3163115hydroxylations
improvisation2052995improvisation_
intoxications22135685_intoxications
lacrimations1645705lacr__imations
oppositions1575125opp_osi__tions
oxidations1845445____oxidations
patronization2456755patronization_
periodizations2655575_periodizations
perorations13314065_pero__rations
perspirations1786175_perspirations
pixilations2045335__p_ixilations
predications17411185__predications
prelibations16127625__prelibations
privations15310105__pr__ivations
probations14311075__pro__bations
proclamations1952695__proclamations
procreations1647275__procreations
procurations1647405__procurations
profanations17175255__profanations
prohibitions1953835__prohibitions
promotions1448775__pro__motions
pronations12314035__pro__nations
propagations1745555__propagations
propitiations1756205__propitiations
prorations12314465__pro__rations
prorogations1556715__prorogations
prostrations1449765__prostrations
protonations1449065__protonations
provocations1956865__provocations
proximities2255885__proximiti_es
purifications2047465_purifications
reoxidations2046045__reoxidations
reprobations1647775repro__bations
spoliations1347695_sp_oli_ations
strobilations1553875_strobilations
terrorizations2356175terrorizations
unappreciations2181635unappreci_ations
vaporizations2776965vap_orizations

Search took 7 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.1101624463.6
2DLD Change Limit95024996.45314725.6
3Display Results99990.0631571.4
 (SQL Overall)178691996.62626968.2
 
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.