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

39 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
uncategorizable29787(None) 
categorical1653115__categorica_l_
categorically21103475__categorically
categorize2254205__categoriz___e
subcategorize27141275subcategoriz___e
unnegotiable1552605un__negoti_able
categorise1354436__categori___se
categorization26104256__categorization
categorized2453716__categoriz__ed
categorizes2354196__categoriz__es
categorizing2553456__categoriz_ing
integrable1348406in__teg_r__able
memorizable2652736____memorizable
negotiable1343976_n___egoti_able
nonnegotiable1661946_nonnegoti_able
satirizable2252026__sat__irizable
subcategorized29121186subcategoriz__ed
subcategorizes28151246subcategoriz__es
subcategorizing308906subcategoriz_ing
unaffordable2152146un_a_ffor_dable
unalterable1345776unalte__r__able
unattainable1453396un_at__tainable
unavoidable1753766un_a__vo_idable
uncapturable1853286unca_ptur__able
uncatchable2053886uncat____chable
uncharitable1984026unc___haritable
uncomfortable2262766unc_omfor_table
uncompromisable2571286uncompromisable
unconformable2263316unc_onfor_mable
undescribable2062486un__describable
undeterminable1962756undete_rminable
unfathomable2261936unfat_ho__mable
unfavorable1953716unfa__vor__able
unmemorable1754836un__memor__able
unpatentable1653686unpate___ntable
unrealizable2354306un__re_alizable
unrecognizable2861626un__recognizable
unutterable1354056unutte__r__able
vaporizable2752096__va__porizable

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.440406115.9
2DLD Change Limit95024398.47011218.9
3Display Results39390.0301300.0
 (SQL Overall)178691398.94019987.8
 
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.