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

51 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
approximative296192(None) 
approximate24132882approximat__e
approximating2761802approximating
approximation2652232approximation
appreciative2153943appreci_ative
appropriative1963023appropriative
approximated26142403approximat_ed
approximately2981573approximately
approximates25112643approximat_es
approximations2761963approximations
applicative2074714app__licative
appointive1793804app_o_i_ntive
appositive1744844app_osi__tive
proximate2045774__proximat__e
achromatize2755435achro__matize
affricative2253035affr__icative
appellative1853075app__ellative
appetitive1753755app_eti__tive
appositives1854255app_osi__tives
appraisive1753205appr_ai__sive
appreciate1655225appreci_at__e
appreciating1954085appreci_ating
appreciation1855285appreci_ation
appreciatively2672305appreci_atively
approbate1546565appro__bat__e
approbating1844585appro__bating
approbation1755025appro__bation
appropriate1464285appropriat__e
appropriating1783495appropriating
appropriation1653825appropriation
aromatize20410305a__ro__matize
associative1653855a_ssoci_ative
authoritative1961985authoritative
depreciative2084085depreci_ative
exploitative2452595explo_itative
inappreciative2361705inappreci_ative
oxidative2044315____oxidative
performative22103875_performative
predicative1947375__predicative
primitive1646395__pr__imitive
privative17188295__pr__ivative
probative1649175__pro__bative
procreative1846315__procreative
prohibitive2152825__prohibitive
promotive1648035__pro__motive
propagative1954505__propagative
provocative2154645__provocative
proximately2552225__proximately
proximities2255885__proximities
reprobative1855645repro__bative
unappreciative2381605unappreci_ative

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 Limit124790519.05013789.0
3Display Results51510.0301700.0
 (SQL Overall)178691519.47018869.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.