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

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

120 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
commemorations195344(None) 
commemoration1853881commemoration_
commemorating1953072commemorati_ng
commemoratives2262422commemoratives
commemorators1862452commemorat_ors
commemorates1753573commemorat__es
commemorative2163043commemorati_ve
commemorator1772613commemorat_o_r
commendations2055803comme_ndations
commensurations21182583commensurations
commiserations2053453commiserations
cogenerations1655914co_generations
collaborations1872744collaborations
colorations13911894co___lorations
commemorate1653664commemorat___e
commemorated1852934commemorat__ed
commemoratively2671914commemoratively
commendation1946514comme_ndation_
commensuration20162984commensuration_
comminations18810484co_m_minations
commiseration1964044commiseration_
commotions1686844co_m_mo__tions
communications22105754communications
communizations29126104communizations
commutations1847264co_m_mutations
compellations1954814compe_llations
compensations19136184compe_nsations
concentrations1877074concentrations
condemnations1845404condem_nations
confederations20104604confederations
consecrations1749214conse_crations
contemplations2074734contemplations
cooperations1659194coope__rations
corporations16129484co__rporations
corroborations1882624corroborations
accommodations23202505accom_modations
ameliorations1563195_ameliorations
botherations1754195bothe__rations
celebrations1645745c_ele_brations
cementations1659015c_eme_ntations
cerebrations1646965c_ere_brations
chemisorptions2381245chemisorptions
coacervations2053875coace_rvations
coeducations1745875co__educations
coevolutions1754085co__evolutions
cogeneration1546445co_generation_
collaboration1763005collaboration_
collimations1656875collim__ations
collocations1646405co__llocations
coloration12913185co___loration_
columniations1764795co_lumniations
combinations1897925co_m_binations
commentating1957045comme_ntati_ng
commentators1854795comme_ntat_ors
commination171111645co_m_mination_
comminutions1894315co_m_minutions
commiserating2053195commiserati_ng
commotion1576985co_m_mo__tion_
communication21106215communication_
communization28116685communization_
commutation1748005co_m_mutation_
compellation1855105compe_llation_
compensation18126505compe_nsation_
competitions1845535compe__titions
compilations1848685co_m_pilations
complexations26134015co_mplexations
complications2147435co_mplications
compositions1846255co_m_positions
compurgations20123895co_mpurgations
computations1848125co_m_putations
concelebrations21103165concelebrations
concentration1758015concentration_
condemnation1746045condem_nation_
condensations1646275conde_nsations
condonations1548005co__ndonations
confederation1995255confederation_
configurations2063705configurations
conflagrations2052725conflagrations
conformations2046725co__nformations
congelations1549735conge__lations
conglobations1853945co_nglobations
conglomerations2062735conglomerations
conjurations2148495co__njurations
connotations1447285co__nnotations
consecration1649785conse_cration_
conservations1849095conse_rvations
considerations1764845considerations
consolations1449745co__nsolations
conspirations1747725co_nspirations
consummations1955155consum_mations
contaminations1886105contaminations
contemplation1985265contemplation_
contestations1547745conte_stations
contortions1348695co__ntor_tions
conversations1847455conve_rsations
convocations1947365co__nvocations
cooperation15410025coope__ration_
coronations13410705co___ronations
corotations1349775co___rotations
corporation151210655co__rporation_
correlations1447865corre__lations
corroboration1782825corroboration_
cremations14410715c__rem__ations
decorations14312885___decorations
enumerations14135515enume__rations
fomentations1746795fo_me_ntations
homologations19102355ho_mologations
immigrations1743725_imm_igrations
immoderations1853075_immoderations
immolations1545475__im_molations
impetrations1645445_impe_trations
meliorations1466755__meliorations
memorizations2649535___memorizations
moderations1448275mo_de__rations
numerations13127295_nume__rations
operations12312955_o_pe__rations
perorations13314065___perorations
recommendations22113095recomme_ndations
redecorations1645085_redecorations
tolerations1158135to_le__rations

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 Limit950241206.61014375.8
3Display Results1201200.0801500.0
 (SQL Overall)1786911207.05025346.2
 
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.