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

52 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
excommunication3062501excommunication_
excommunicating3172192excommunicati_ng
communication21106213__communication_
communicational2383073__communicational
communications22105753__communications
excommunicative3372273excommunicati_ve
excommunicator2972313excommunicat_o_r
excommunicators3072083excommunicat_ors
communicating2254874__communicati_ng
communization28116684__communization_
communizations29126104__communizations
excommunicate2882784excommunicat___e
excommunicated3062474excommunicat__ed
excommunicates2972594excommunicat__es
communicative2454665__communicati_ve
communicator2054455__communicat_o_r
communicators2173985__communicat_ors
communicatory2463575__communicat_ory
incommunicative2672365incommunicati_ve
uncommunicative2692355uncommunicati_ve
columniation1665426__columni_ation_
columniations1764796__columni_ations
commendation1946516__commen_dation_
commendations2055806__commen_dations
commination171111646__comm__ination_
comminations18810486__comm__inations
communicant1955346__communica___nt
communicate1956186__communicat___e
communicated2154916__communicat__ed
communicatee2055086__communicat__ee
communicatees2163646__communicat_ees
communicates2055616__communicat__es
communicatively2982956__communicatively
communitarian1963126__communitarian_
communitarians2062486__communitarians
commutation1748006__commu__tation_
commutations1847266__commu__tations
complication2048206__co_mplication_
complications2147436__co_mplications
compunction19115906__compun_c_tion_
compunctions20145696__compun_c_tions
excogitation2254196exco___gitation_
excogitations2353836exco___gitations
excoriation2048436exco___ri_ation_
excoriations2147526exco___ri_ations
excruciation23123316exc__ruci_ation_
excruciations24112996exc__ruci_ations
immunization25115916___immunization_
immunizations26115346___immunizations
incommunicado2271826incommunica_do__
recommendation2183226recommen_dation_
recommendations22113096recommen_dations

Search took 5 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 Filter178691658740.360496363.9
2DLD Change Limit65874524.04616281.3
3Display Results52520.0331575.8
 (SQL Overall)178691524.43940254.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.