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

76 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
communication2110621(None) 
communications22105751communications
communization28116681communization
communicating2254872communicating
communicational2383072communicational
communicative2454662communicative
communicator2054452communicat_or
communizations29126102communizations
excommunication3062502excommunication
columniation1665423columni_ation
commendation1946513commen_dation
commination171111643comm__ination
communicate1956183communicat__e
communicated2154913communicat_ed
communicatee2055083communicat_ee
communicatees2163643communicatees
communicates2055613communicat_es
communicators2173983communicators
communicatory2463573communicatory
communitarian1963123communitarian
commutation1748003commu__tation
complication2048203co_mplication
compunction19115903compun_c_tion
immunization25115913_immunization
ammoniation1545904_ammoni_ation
ammunition14103814_ammuni__tion
calumniation1663994calumni_ation
claudication1753324c_laudication
coalification2046134coalification
cocainization2655954cocainization
codification20108074co_dification
coeducation1646234coedu__cation
cofunction1745254co_fun_c_tion
colonisation14176764co_lonisation
colonization232010234co_lonization
columniations1764794columni_ations
combination17108804co_m_bination
commemoration1853884commemoration
commendations2055804commen_dations
commensuration20162984commensuration
comminations18810484comm__inations
comminution17105014comm__inution
commiseration1964044commiseration
commodification2791874commodification
communicable2254024communica_ble
communicably2553764communica_bly
communicant1955344communica__nt
communicants2053954communica_nts
communicatively2982954communicatively
communion1546364commun____ion
communistic1954384communi_sti_c
communitarians2062484communitarians
communities1747274communi__ties
commutations1847264commu__tations
compensation18126504compen_sation
compilation1749314co_m_pilation
complications2147434co_mplications
compunctions20145694compun_c_tions
compurgation19134184compu_rgation
computation1748714compu__tation
conjunction2245624conjun_c_tion
cornification2046694cornification
coruscation1545694co_ru_scation
domestication18114544domestication
excommunicating3172194excommunicating
excommunicative3372274excommunicative
excommunicator2972314excommunicat_or
fornication1645954fo__rnication
hominization2657994ho_minization
immunizations26115344_immunizations
incommunicative2672364incommunicative
mummification2154314mummification
romanization2389894ro_manization
sonication12411184so___nication
uncommunicative2692354uncommunicative
zombification3154064zombification

Search took 6 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 Limit95024765.26618044.8
3Display Results76760.0461652.2
 (SQL Overall)178691765.67231504.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.