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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

123 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
excommunication306250(None) 
communication21106212__communication
excommunicating3172192excommunicating
excommunicative3372272excommunicative
excommunicator2972312excommunicat_or
communications22105753__communications
communization28116683__communization
excommunicate2882783excommunicat__e
excommunicated3062473excommunicat_ed
excommunicates2972593excommunicat_es
excommunicators3072083excommunicators
communicating2254874__communicating
communicational2383074__communicational
communicative2454664__communicative
communicator2054454__communicat_or
communizations29126104__communizations
incommunicative2672364incommunicative
uncommunicative2692354uncommunicative
columniation1665425__columni_ation
commendation1946515__commen_dation
commination171111645__comm__ination
communicate1956185__communicat__e
communicated2154915__communicat_ed
communicatee2055085__communicat_ee
communicatees2163645__communicatees
communicates2055615__communicat_es
communicators2173985__communicators
communicatory2463575__communicatory
communitarian1963125__communitarian
commutation1748005__commu__tation
complication2048205__co_mplication
compunction19115905__compun_c_tion
excogitation2254195exco___gitation
excoriation2048435exco___ri_ation
excruciation23123315exc__ruci_ation
immunization25115915___immunization
incommunicado2271825incommunica_do_
recommendation2183225recommen_dation
accommodation22152616accomm__odation
ammoniation1545906___ammoni_ation
ammunition14103816___ammuni__tion
axiomatisation23152126axio_matisation
axiomatization32134056axio_matization
calumniation1663996__calumni_ation
claudication1753326__c_laudication
coalification2046136__coalification
cocainization2655956__cocainization
codification20108076__co_dification
coeducation1646236__coedu__cation
cofunction1745256__co_fun_c_tion
colonisation14176766__co_lonisation
colonization232010236__co_lonization
columniations1764796__columni_ations
combination17108806__co_m_bination
commemoration1853886__commemoration
commendations2055806__commen_dations
commensuration20162986__commensuration
comminations18810486__comm__inations
comminution17105016__comm__inution
commiseration1964046__commiseration
commodification2791876__commodification
communicable2254026__communica_ble
communicably2553766__communica_bly
communicant1955346__communica__nt
communicants2053956__communica_nts
communicatively2982956__communicatively
communion1546366__commun____ion
communistic1954386__communi_sti_c
communitarians2062486__communitarians
communities1747276__communi__ties
commutations1847266__commu__tations
compensation18126506__compen_sation
compilation1749316__co_m_pilation
complications2147436__co_mplications
compunctions20145696__compun_c_tions
compurgation19134186__compu_rgation
computation1748716__compu__tation
conjunction2245626__conjun_c_tion
cornification2046696__cornification
coruscation1545696__co_ru_scation
decolonization26146026deco_lonization
decompensation2193366decompen_sation
decortication1857536deco__rtication
domestication18114546__domestication
enunciation1345466e____nunciation
examination2058456ex__am__ination
excitation19410176exc_____itation
exclamation22104636exclam____ation
excogitations2353836exco___gitations
excoriations2147526exco___ri_ations
excruciations24112996exc__ruci_ations
exculpation2244876exc___u_lpation
exemplification3161596exemplification
exfoliation2145256exfo___li_ation
exoneration1847656ex_o___neration
explication2248456ex____plication
exponentiation2361796expo_nentiation
expostulation2262616expostu__lation
expunction2143576ex___pun_c_tion
exsanguination2261596exsangu_ination
extemporisation2661776extemporisation
extemporization3562436extemporization
extermination2275746exterm__ination
extrication2049796ex____trication
exuviation20116346ex____uvi_ation
fornication1645956__fo__rnication
hominization2657996__ho_minization
immunizations26115346___immunizations
incommunicable2462816incommunica_ble
incommunicably2762706incommunica_bly
mummification2154316__mummification
overcommunicate2672436overcommunicat__e
pronunciation17113226_pro_nunciation
recodification22125666reco_dification
recolonization25155886reco_lonization
recombination19106176reco_m_bination
recommendations22113096recommen_dations
recompilation1955156reco_m_pilation
recomputation1974396recompu__tation
romanization2389896__ro_manization
sonication12411186__so___nication
uncommunicable2462856uncommunica_ble
zombification3154066__zombification

Search took 7 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.346516448.0
2DLD Change Limit950241236.36014940.9
3Display Results1231230.0931322.6
 (SQL Overall)1786911236.79926282.0
 
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.