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

154 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
commiserations205345(None) 
commiseration1964041commiseration_
commiserating2053192commiserati_ng
commemorations1953443commemorations
commensurations21182583commensurations
comminations18810483commi__nations
commiserates1853603commiserat__es
commiserative2283273commiserati_ve
considerations1764843considerations
chemisorptions2381244chemisorptions
cogenerations1655914co_generations
combinations1897914combi__nations
commemoration1853884commemoration_
commendations2055804comm_endations
commensuration20162984commensuration_
commination171111644commi__nation_
comminutions1894314commi__nutions
commiserate1753894commiserat___e
commiserated1963064commiserat__ed
commiseratingly2571264commiseratingly
commissions1745264commis___sions
communications22105754communications
communizations29126104communizations
commutations1847264comm__utations
compilations1848674compi__lations
complexations26134014co_mplexations
confederations20104604confederations
configurations2063704configurations
confiscations2044954confis_cations
consecrations1749214co__nsecrations
conservations1849094co__nservations
consideration1655524consideration_
cooperations1659194co__operations
immigrations1743724_immi_grations
immoderations1853074_immoderations
obliterations1553454_obliterations
vociferations2153114vo_ciferations
administrations18162405administrations
admirations1446695_admi__rations
alliterations1384555_alliterations
bombinations1884585bombi__nations
botherations1754195bo__therations
calibrations1645155c_ali_brations
caseations1258305c___ase_ations
castrations13410055c___astrations
chemisorption22101395chemisorption_
chrismations1953045c_hris_mations
coacervations2053875co__acervations
coalifications2155705coalifications
cocainizations2755435cocainizations
codifications21127625co_difications
codirections1744695co_dire_ctions
cogeneration1546445co_generation_
cogitations1448905co_gi__tations
collaborations1872745collaborations
colligations1556835colli__gations
collimations1656875colli__mations
colonisations15216175colonis__ations
colorations13911895co___lorations
combination17108805combi__nation_
combustions1744525combus___tions
commemorating1953075commemorati_ng
commemoratives2262425commemoratives
commemorators1862455commemorat_ors
commendation1946515comm_endation_
comminution17105015commi__nution_
commissariats1961355commis_sariats
commissaries1852875commis_sari_es
commission1645625commis___sion_
commotions1686845comm____otions
communication21106215communication_
communization28116685communization_
commutation1748005comm__utation_
compellations1954805co_mpellations
compensations19136185co_mpensations
competitions1845535co_m_petitions
compilation1749315compi__lation_
completions1746905co_mple__tions
complexation25144245co_mplexation_
complications2147435co_mplications
compositions1846255compos__itions
compurgations20123895co_mpurgations
computations1848125co_m_putations
concatenations1873725concatenations
concelebrations21103165concelebrations
concentrations1877075concentrations
conciliations1747205conci_liations
confederation1995255confederation_
configuration1954135configuration_
confirmations2055675confi_rmations
confiscation1945535confis_cation_
conflagrations2052725conflagrations
congelations1549735co__ngelations
conglomerations2062735conglomerations
congregations17186415co_ngregations
conjurations2148495co__njurations
consecration1649785co__nsecration_
consecutions1647045co__nsecutions
conservation1749405co__nservation_
consignations16105935consi_gnations
consolations1449735co__nsolations
conspirations1747725co_nspirations
consternations16116045co_nsternations
contestations1547735contes_tations
continuations1547145conti_nuations
conversations1847455co__nversations
cooperation15410025co__operation_
cornifications2145955cornifications
corporations16129485co__rporations
correlations1447865co__rrelations
corroborations1882615corroborations
coruscations1645245co_rus_cations
counteractions1855025co_unteractions
criminations1648065crimi__nations
culminations1646535culmi__nations
deliberations1645535_deliberations
demonstrations1795675demonstrations
desiderations1545675_desiderations
dominations14611045do_mi__nations
emigrations14187155__emi_grations
enumerations14135515enum__erations
eviscerations1882705__eviscerations
hominizations2767455ho_minizations
immigration1644175_immi_gration_
immoderation1753435_immoderation_
incinerations1545685_incinerations
iterations10413825____iterations
itinerations1245685__itinerations
liberations1358945___liberations
literations11610585___literations
macerations1548475___macerations
mensurations1445715__mensurations
migrations13168685___mi_grations
ministrations1555445_ministrations
miscreations1647055___miscreations
moderations1448275___moderations
mummifications2254015mummifications
nominations13410535no_mi__nations
numerations13127295_num__erations
obliteration1453895_obliteration_
observations1785015_o__bservations
operations12312955_o___perations
proliferations1952705proliferations
refrigerations1863775refrigerations
registrations1446895_registrations
reiterations12410875__reiterations
remigrations15227795_remi_grations
remonstrations16116485remonstrations
remunerations1556205_remunerations
solmizations2346635solmi__zations
tolerations1158135to___lerations
verbigerations2052475verbigerations
vociferation2053185vo_ciferation_
zombifications3263765zombifications

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.1261418182.5
2DLD Change Limit950241546.50014619.1
3Display Results1541540.0931655.9
 (SQL Overall)1786911546.71926594.9
 
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.