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

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
communicable225402(None) 
communicably2553761communicably
communicate1956182communica_te
communicatee2055082communicatee
incommunicable2462812incommunicable
uncommunicable2462852uncommunicable
commandable2053293comman_dable
commendable2054343commen_dable
communicant1955343communica_nt
communicants2053953communicants
communicated2154913communicated
communicatees2163643communicatees
communicates2055613communicates
communicative2454663communicative
communicator2054453communicator
commutable1845343commu__table
incommunicably2762703incommunicably
cognizable2443394co__gnizable
combinable1844724co_m_binable
commendably2353664commen_dably
commensurable2162294commensurable
committable1953494comm_ittable
communal1446354commun__a_l_
communally1945004commun__ally
communicability2862514communicability
communicating2254874communicating
communication21106214communication
communicators2173984communicators
communicatory2463574communicatory
communique2552994communi__que
communise1546804communi___se
communize2446284communi___ze
companionable2162534companionable
compensable1955194compen_sable
compoundable2161584compoun_dable
computable1855724compu__table
countable1348854co__un_table
excommunicate2882784excommunica_te
immedicable2053214_immedicable

Search took 8 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.423422437.4
2DLD Change Limit124790397.04617710.8
3Display Results39390.0331181.8
 (SQL Overall)178691397.50223819.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.