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

69 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
appropriative196302(None) 
appropriate1464282appropriat__e
appropriating1783492appropriating
appropriation1653822appropriation
appreciative2153963appr_eciative
appropriable1762713appropria_ble
appropriated1663493appropriat_ed
appropriately1962653appropriately
appropriates1564073appropriat_es
appropriations1763173appropriations
appropriator1563603appropriat_or
appropriators1663383appropriators
approximative2961923approximative
appointive1793804app_o__intive
appositive1744844app_o_si_tive
appropriateness1891584appropriateness
expropriate2253784expropriat__e
expropriating2553244expropriating
expropriation2453994expropriation
inappropriate16112274inappropriat__e
procreative1846314__procreative
propagative1954504__propagative
reappropriate1682424reappropriat__e
reappropriating1991904reappropriating
appellative1853075app__ellative
appetitive1753755app__eti_tive
applicative2074715app__licative
appositives1854255app_o_si_tives
appraisive1753205appr__ai_sive
appreciate1655245appr_eciat__e
appreciating1954105appr_eciating
appreciation1855305appr_eciation
appreciatively2672315appr_eciatively
approbate1546565appro__bat__e
approbating1844585appro__bating
approbation1755025appro__bation
approximate24132885approximat__e
approximating2761805approximating
approximation2652235approximation
associative1653855a_sso_ciative
assortative1473955a_sso_rtative
authoritative1961985autho_ritative
corporative1847155corpo_r_ative
depreciative2084095depr_eciative
explorative2354245explo_r_ative
expropriated2452995expropriat_ed
expropriates23103405expropriat_es
expropriations2553325expropriations
expropriator2363015expropriat_or
expropriators2462895expropriators
improprieties19142795improprieties
inappreciative2361705inappr_eciative
inappropriately2171835inappropriately
misappropriate19172125misappropriat__e
pejorative2245695_pejo_r_ative
performative22103875_performative
portative1449375__p_o_rtative
preoperative1955755_preoperative
preparative1846355__preparative
probative1649175__pro__bative
proprieties1556185__proprieties
proscriptive2152875__proscriptive
protractive1855635__protractive
provocative2154645__provocative
reappropriated1872105reappropriat_ed
reappropriates17102255reappropriat_es
reprobative1855645repro__bative
unappreciative2381605unappr_eciative
unappropriated1872075unappropriat_ed

Search took 9 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 Limit124790697.92315750.3
3Display Results69690.0461500.0
 (SQL Overall)178691698.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.