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

75 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
approximating276180(None) 
approximation2652232approximation
approximations2761962approximations
approximative2961922approximative
appreciating1954083appreci_ating
approbating1844583appro__bating
appropriating1783493appropriating
approximate24132883approximat__e
approximated26142403approximat_ed
approximately2981573approximately
approximates25112643approximat_es
appointing1545324app_o_i_nting
asphyxiating2861184asphyxi_ating
abbreviating2051565abbrevi_ating
abominating1644845a__bominating
abrogating1497985a_bro__gating
acclimating1845285a__cclimating
affricating2043965affr__icating
ammoniating1644065a_mmoni_ating
animating12312505a____nimating
apocopating1853235a_p_ocopating
apportioning1753095apporti_oning
appraising1545765appr_ai__sing
appreciation1855285appreci_ation
appreciations1964755appreci_ations
appreciative2153945appreci_ative
apprising1447965appr__i__sing
apprizing2347195appr__i__zing
approaching2162455appro__aching
approbation1755025appro__bation
approbations1854245appro__bations
appropriation1653825appropriation
appropriations1763175appropriations
appropriative1963025appropriative
approving1745055appro____ving
arointing1049365a__ro_i_nting
arpeggiating1751265arpeggi_ating
arrogating121778395a_rro__gating
aspirating1348365asp___irating
associating1444865a_ssoci_ating
automating1389305a_uto__mating
bromating1439165__bro__mating
brominating1696085__brominating
depreciating1845035depreci_ating
detoxicating2353865_detoxicating
expropriating2553245expropriating
hydroxylating3163245hydroxylating
intoxicating2254125_intoxicating
oppilating1544855opp___ilating
oxidating1845055____oxidating
patriating13510205patr__i_ating
perorating13313135_pero__rating
peroxiding2144935_peroxi__ding
postmating1548605__p_ostmating
predicating1749655__predicating
prelimiting1645385__prelimiting
probating14311185__pro__bating
procreating1647695__procreating
profiting1549985__profi__ting
prohibiting1953935__prohibiting
promoting1439915__pro__moting
prompting1637195__pro__mpting
pronating12313765__pro__nating
propagating1754885__propagating
propitiating1755005__propitiating
prorating12314285__pro__rating
prorogating1556055__prorogating
prostrating1449395__prostrating
protonating1448585__protonating
proximate2045775__proximat__e
proximately2552225__proximately
proximities2255885__proximities
reappropriating1991905reappropriating
reprobating1647105repro__bating
spoliating1366965_sp_oli_ating

Search took 8 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.1561145455.1
2DLD Change Limit124790757.75016101.9
3Display Results75750.0461630.4
 (SQL Overall)178691757.95222471.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.