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

103 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
approximation265223(None) 
approximations2761961approximations
approximating2761802approximating
approximative2961922approximative
appreciation1855283appreci_ation
approbation1755023appro__bation
appropriation1653823appropriation
approximate24132883approximat__e
approximated26142403approximat_ed
approximately2981573approximately
approximates25112643approximat_es
application1747474app__lication
apposition1446594app_osi__tion
appreciations1964754appreci_ations
approbations1854244appro__bations
appropriations1763174appropriations
asphyxiation2761384asphyxi_ation
autoxidation2053784a_utoxidation
epoxidation2144064_ep_oxidation
improvisation2052994improvisation
patronization2456754patronization
abbreviation191175265abbrevi_ation
abomination1547485a__bomination
abrogation13107335a_bro__gation
acclimation17127095a__cclimation
accreditation18112875accreditation
aldolization2246735a_ldolization
ammoniation1545905a_mmoni_ation
amortization2347205amor_tization
amplification2275185amplification
animation11313685a____nimation
anodization2187645a__nodization
apparition1444585app_ari__tion
appellation1564125app__ellation
applications1846775app__lications
apportion1347005app_o___rtion
appositions1546155app_osi__tions
appreciating1954085appreci_ating
appreciative2153945appreci_ative
appreciator1754115appreci_at_or
approbating1844585appro__bating
appropriating1783495appropriating
appropriative1963025appropriative
appropriator1563595appropriat_or
arborization2347885a_rborization
arrogation11107445a_rro__gation
asphyxiations2861335asphyxi_ations
aspiration1249995asp___iration
association1346155a_ssoci_ation
atomization2249245a__tomization
authorization2555855authorization
automation1249145a_uto__mation
autoxidations2153555a_utoxidations
bromination1547815__bromination
caprification2256055caprification
deoxidation2045955__deoxidation
depreciation1747075depreci_ation
deprivation1788775depr__ivation
detoxication2246205_detoxication
epoxidations2243645_ep_oxidations
erotization20412065__erotization
exploitation2154705explo_itation
expropriation2453995expropriation
hydroxylation3063355hydroxylation
improvisations2152535improvisations
intoxication21156355_intoxication
lacrimation1546265lacr__imation
opposition1445485opp_osi__tion
oxidation1746325____oxidation
patronizations2576195patronizations
periodization2556065_periodization
peroration12316005_pero__ration
perspiration1656835_perspiration
pixilation1945915__p_ixilation
predication16412435__predication
prelibation15128665__prelibation
privation14311175__pr__ivation
probation13412185__pro__bation
proclamation1853415__proclamation
procreation1547955__procreation
procuration1548295__procuration
profanation16186105__profanation
prohibition1854265__prohibition
promotion1359505__pro__motion
pronation11415705__pro__nation
propagation1646445__propagation
propitiation1656915__propitiation
proration11415985__pro__ration
prorogation1447395__prorogation
prostration13410795__prostration
protonation13510435__protonation
provocation1847355__provocation
proximate2045775__proximat__e
proximately2552225__proximately
proximities2255885__proximities
purification1948175_purification
reoxidation1946655__reoxidation
reprobation1548505repro__bation
spoliation1248425_sp_oli_ation
strobilation1454045_strobilation
terrorization2256665terrorization
unappreciation2061965unappreci_ation
vaporization2697535vap_orization

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.1401276364.3
2DLD Change Limit1247901039.40613267.1
3Display Results1031030.0801287.5
 (SQL Overall)1786911039.62618563.4
 
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.