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

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

71 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
postoperatively2591261postoperatively_
postoperative2063283postoperative___
cooperatively2354194co__operatively_
preoperatively2462964p_reoperatively_
operatively1946275____operatively_
postpositively2471395post_positively_
vituperatively2561785_vituperatively_
comparatively2553716co__mparatively_
cooperative1847056co__operative___
cooperatives1965556co__operative__s
imperatively2255576___imperatively_
iteratively1745916__it__eratively_
nonoperative1756286no_noperative___
pejoratively2753676p_ejo__ratively_
preoperative1955756p_reoperative___
preparatively2353646p__reparatively_
prospectively2553156pros__pe_ctively_
reiteratively1953796reit__eratively_
superlatively2174056__s_uperlatively_
alliteratively2062047_alliteratively_
alternatively1952727_alt__ernatively_
assertively1774087_as__ser_tively_
associatively2162377_asso_ciatively_
assortatively1962327_asso_rtatively_
collaboratively2571547collaboratively_
commemoratively2671917commemoratively_
competitively2562817co__mpetitively_
connotatively21102687conno__tatively_
conservatively25133877co__nservatively_
contemplatively2771897contemplatively_
contrastively2153867cont___rastively_
cooperativeness2273377co__operativeness
correlatively2153217co__rrelatively_
decoratively2154447_deco__ratively_
deliberatively2372017_deliberatively_
desperately1753737des__perat__ely_
dispersively2153527dis__per_sively_
exploratively2862427explo__ratively_
federatively2253907___federatively_
hortatively2054057hort____atively_
inoperative1646757__inoperative___
interactively2155177_int__eractively_
noncooperative21113477noncooperative___
operative141110557____operative___
operatives15117887____operative__s
optatively1864647____op_tatively_
ostensively1753717_ost__e_nsively_
perspectively2553277p_erspe_ctively_
photonegative2263397photonegative___
positively1845457pos_____itively_
possessively2052977pos__se_ssively_
postcranially2061717post__cranially_
postdelivery2161197post_de__livery_
posteriorly1652687post__er__iorly_
posterities1369047post__eriti_e__s
posteruptive1962227post__eruptive___
postpositive1963127post_positive___
prefiguratively2771307prefiguratively_
projectively2953987p__roje_ctively_
protectively2254727p__rote_ctively_
provocatively2662337p__rovocatively_
putatively1845067p_ut____atively_
remuneratively2262597_remuneratively_
respectively2285187res__pe_ctively_
restorative1446947resto__rative___
restoratives1554167resto__rative__s
rotatively1645407ro_t____atively_
sportively1845027__s__por_tively_
tolerative1346257___tolerative___
uncooperative2083107uncooperative___
vituperative2072187_vituperative___

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.376475242.0
2DLD Change Limit95024718.21611565.7
3Display Results71710.0461543.5
 (SQL Overall)178691718.63820686.6
 
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.