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

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

38 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
misappropriated2117200(None) 
misappropriate19172121misappropriate_
misappropriates20192001misappropriates
appropriated1663493___appropriated
inappropriate16112273_inappropriate_
reappropriated1872103_reappropriated
unappropriated1872073_unappropriated
appropriate1464284___appropriate_
appropriates1564064___appropriates
inappropriately2171834_inappropriately
reappropriate1682424_reappropriate_
reappropriates17102254_reappropriates
appropriately1962655___appropriately
appropriator1563595___appropriator
disappointed1852855disapp_o__inted
expropriated2452995___expropriated
misprogramed2051905mis__progr_amed
appreciated1854206___appr_eciated
approbated1744766___appro__bated
appropriable1762716___appropriable
appropriating1783496___appropriating
appropriation1653826___appropriation
appropriative1963026___appropriative
appropriators1663376___appropriators
approximated26142406___approximated
disapproved2062566disappro____ved
disassociated1762576disa_sso_ciated
expropriate2253786___expropriate_
expropriates23103406___expropriates
misallocated1762356misa_llo__cated
misapplied1742766misa_p__pli__ed
misapprehended25101136misappr_ehended
mispointed1545576mis__p_o__inted
misprinted1545986mis_____printed
misprogrammed2061696mis__programmed
misreported1653176misrep_o_r__ted
reappropriating1991906_reappropriating
unappreciated2062456_unappr_eciated

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 Filter178691950240.1231452772.4
2DLD Change Limit95024388.30011448.7
3Display Results38380.0301266.7
 (SQL Overall)178691388.45321139.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.