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

55 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
excommunicators307208(None) 
excommunicator2972311excommunicator_
communicators2173982__communicators
excommunicates2972592excommunicat_es
communicator2054453__communicator_
communicatory2463573__communicatory
excommunicate2882783excommunicat__e
excommunicated3062473excommunicat_ed
excommunicating3172193excommunicating
excommunication3062503excommunication
excommunicative3372273excommunicative
communicatees2163644__communicatees
communicates2055614__communicat_es
communications22105754__communications
commentators1854795__commen_tators
communicants2053955__communica_nts
communicate1956185__communicat__e
communicated2154915__communicat_ed
communicatee2055085__communicat_ee
communicating2254875__communicating
communication21106215__communication
communicative2454665__communicative
communizations29126105__communizations
commutators1754435__commu__tators
incommunicado2271825incommunicado__
incommunicative2672365incommunicative
uncommunicative2692355uncommunicative
accommodators2261746accomm__odators
calumniators1652206__calumni_ators
commemorators1862456__commemorators
commendatory2253236__commen_datory
commentator1755276__commen_tator_
comminatory2055246__comm__inatory
communicable2254026__communica_ble
communicably2553766__communica_bly
communicant1955346__communica__nt
communicational2383076__communicational
communions1656186__communi___ons
communists1646236__communi_st__s
communities1747276__communi__ties
communization28116686__communization
commutator1644676__commu__tator_
compensators1854376__compen_sators
compurgators19102946__compu_rgators
decorticators1862506deco__rticators
enunciators13114136e____nunciators
explicators2244716ex____plicators
exterminators2252966exterm__inators
fornicators1663736__fo__rnicators
incommunicable2462816incommunica_ble
incommunicably2762706incommunica_bly
overcommunicate2672436overcommunicat__e
recommendatory24121406recommen_datory
sonicators1277066__so___nicators
uncommunicable2462856uncommunica_ble

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 Filter178691950240.360496363.9
2DLD Change Limit95024557.12613334.8
3Display Results55550.0461195.7
 (SQL Overall)178691557.53223724.2
 
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.