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

162 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
commiseration196404(None) 
commiserations2053451commiserations
commiserating2053192commiserating
commiserative2283272commiserative
commemoration1853883commemoration
commensuration20162983commensuration
commination171111643commi__nation
commiserate1753893commiserat__e
commiserated1963063commiserat_ed
commiserates1853613commiserat_es
consideration1655523consideration
chemisorption22101394chemisorption
cogeneration1546444co_generation
combination17108804combi__nation
commemorations1953444commemorations
commendation1946514comm_endation
commensurations21182584commensurations
comminations18810484commi__nations
comminution17105014commi__nution
commiseratingly2571264commiseratingly
commission1645624commis___sion
communication21106214communication
communization28116684communization
commutation1748004comm__utation
compilation1749314compi__lation
complexation25144244co_mplexation
confederation1995254confederation
configuration1954134configuration
confiscation1945534confis_cation
consecration1649784co__nsecration
conservation1749404co__nservation
considerations1764844considerations
cooperation15410024co__operation
immigration1644174_immi_gration
immoderation1753434_immoderation
obliteration1453894_obliteration
vociferation2053184vo_ciferation
administration17142555administration
admiration1347735_admi__ration
alliteration1285165_alliteration
bombination1765015bombi__nation
botheration1654655bo__theration
calibration1545995c_ali_bration
caseation1199515c___ase_ation
castration12410805c___astration
chemisorptions2381245chemisorptions
chrismation1853515c_hris_mation
coacervation1964275co__acervation
coalification2046135coalification
cocainization2655955cocainization
codification20108075co_dification
codirection1644745co_dire_ction
cogenerations1655915co_generations
cogitation13410085co_gi__tation
collaboration1763005collaboration
colligation1457455colli__gation
collimation1557575colli__mation
colonisation14176765colonis__ation
coloration12913185co___loration
combinations1897925combi__nations
combustion1644565combus___tion
commemorating1953075commemorating
commemorative2163045commemorative
commemorator1772615commemorat_or
commendations2055805comm_endations
comminutions1894315commi__nutions
commissarial1862015commis_sarial
commissariat1862535commis_sariat
commissaries1852885commis_saries
commissions1745265commis___sions
commodification2791875commodification
commotion1576985comm____otion
communications22105755communications
communizations29126105communizations
commutations1847265comm__utations
compellation1855105co_mpellation
compensation18126505co_mpensation
competition1755775co_m_petition
compilations1848685compi__lations
completion1647305co_mple__tion
complexations26134015co_mplexations
complication2048205co_mplication
composition1746795compos__ition
compurgation19134185co_mpurgation
computation1748715co_m_putation
computerization3082785computerization
concatenation1764095concatenation
concelebration20133565concelebration
concentration1758015concentration
conciliation1648235conci_liation
confederations20104605confederations
configurations2063705configurations
confirmation1946185confi_rmation
confiscations2044955confis_cations
conflagration1953015conflagration
congelation14410345co__ngelation
conglomeration1963005conglomeration
congregation16226765co_ngregation
conjuration2049515co__njuration
consecrations1749215co__nsecrations
consecution1547315co__nsecution
conservations1849095co__nservations
consignation15136315consi_gnation
consolation13410985co__nsolation
conspiration1648385co_nspiration
consternation15106365co_nsternation
contestation1448665contes_tation
continuation1448195conti_nuation
conversation1747805co__nversation
cooperations1659195co__operations
cornification2046695cornification
corporation151210655co__rporation
correlation1358555co__rrelation
corroboration1782825corroboration
coruscation1545695co_rus_cation
counteraction1755385co_unteraction
crimination1549415crimi__nation
culmination1557645culmi__nation
deliberation1546365_deliberation
demonstration16126285demonstration
desideration1456395_desideration
domination13712375do_mi__nation
emigration13228215__emi_gration
enumeration13105915enum__eration
evisceration1773005__evisceration
hominization2657995ho_minization
immigrations1743725_immi_grations
immoderations1853075_immoderations
incineration1446295_incineration
inconsideration1871865inconsideration
iteration9515035____iteration
itineration1156325__itineration
liberation1269995___liberation
literation10511415___literation
maceration1449615___maceration
mensuration1346495__mensuration
migration12179705___mi_gration
ministration1465835_ministration
miscreation1547725___miscreation
moderation1348655___moderation
mummification2154315mummification
nomination12712105no_mi__nation
numeration12137965_num__eration
obliterations1553455_obliterations
observation1665065_o__bservation
operation11314005_o___peration
postisolation1553575postisolation
postliberation1892055postliberation
premigration1755695premi_gration
proliferation1853035proliferation
reconsideration18112585reconsideration
refrigeration1764155refrigeration
registration1347545_registration
reiteration11412175__reiteration
remigration14228915_remi_gration
remonstration15117125remonstration
remuneration1446935_remuneration
solmization2247325solmi__zation
toleration1048965to___leration
verbigeration1952865verbigeration
vociferations2153115vo_ciferations
zombification3154065zombification

Search took 9 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 Filter1786911247900.406440125.6
2DLD Change Limit1247901628.43614792.6
3Display Results1621620.1101472.7
 (SQL Overall)1786911628.95219961.0
 
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.